(Newbie) Copying values from an array to the worksheet

S

Srdjan Kovacevic

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
 
T

Tom Ogilvy

rws = Ubound(varArray,1)-Lbound(varArray,1)+1
cls = Ubound(varArray,2) - Lbound(varArray,2) + 1
Range("A1").Resize(rws,cls) = varArray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top