Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
(Newbie) Copying values from an array to the worksheet
rws = Ubound(varArray,1)-Lbound(varArray,1)+1
cls = Ubound(varArray,2) - Lbound(varArray,2) + 1 Range("A1").Resize(rws,cls) = varArray -- Regards, Tom Ogilvy "Srdjan Kovacevic" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie: Copying row of values to a column | Excel Discussion (Misc queries) | |||
copying an entire worksheet - need absolute values | Excel Worksheet Functions | |||
Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) | |||
Array of Values from Worksheet Range - What does it 'look' like? | Excel Programming | |||
Copying an array to a worksheet: Excel 97 vs 2000 | Excel Programming |