Hi
I spotted the problem. An array is not an object! you want
Arr(j, 2) =
not
Arr(j,2).Value =

Paul

wrote:
Hi
Dim Arr() as integer

is sensible. I notice a colon in your text - did you type

Dim Arr(): as integer ??????

regards
Paul

Buffyslay wrote:
arh, yes - i knew that the reDim was incorrect...

if i dim ":as integer" but now getting a new error...
Compile error: Invalid Qualifier