Matrix MACRO "GetCells2"

[#1]

Hi,

My macro always gets an error if I wanna get matrix values from a chart

e.g.

set matrix=obj.getcells2(0,0,rownumber,columnnumber) this works fine

however, if i change the 0,0, to say 2,2 > error...!!

Why??

Please help - thanks alot

[#2 · Accepted solution]

Do you still use rownumber and columnumber with your 2,2 call?

This might throw an error as the matrix does not contain enough cells. Can you try

set matrix=obj.getcells2(2,2,1,1)

[#3]

works now thanks lot

it seems there has to be at least 2 cells in between!