View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Srdjan Kovacevic[_5_] Srdjan Kovacevic[_5_] is offline
external usenet poster
 
Posts: 3
Default (Newbie) Copying values from an array to the worksheet

The catch is this: the array is 2-dimensional and it's not fixed in size, so
I can't define the worksheet range in advance.

The array is quadratic and its dimension is user defined; i.e.

ReDim varArray(varN, varN) as Integer

varN can be anywhere from 100 to 500.

Can I copy the contents of this aray to the worksheet just by refering the
anchor cell (i.e. the top-left cell)?

I've tried:

Range("A1").value = varArray

and it just pulls the varArray(1,1) value.

I've also tried

Range("A1").Offset(varN, varN).value = varArray

but the debugger reports an error (he probably doesn't recognize the object
I'm refering to).

please CC: your reply to

srdan.kovacevic(a)fsb.hr

(a) is obviously the monkey-sign (spamspoofer)

Thanks in advance!
srdan