| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Output Array Values
Thank you very much!
Raul "Norman Jones" wrote: Hi Raul, Try: arr = Range(Cells(1, 1), Cells(2000, 30)).Value --- Regards, Norman "Raul" wrote in message ... Norman, I did not mean to imply that your syntax was incorrect. I was asking for the syntax to use if I wanted to refer to the range using something like the following pseudocode: xxx = Range(cell(RowNum,ColNum)).Resize(NumOfRows, NumOfCols).Value I like to use row and column indexes to make this code snippet more flexible. Thanks, Raul "Norman Jones" wrote: Hi Raul, By the way, what is the proper syntax for xxx = Range("A1").Resize(2000, 30).Value I could have used the equivalent: Arr = range("A1:AD2000") I used the original sytax (which, by the way, is perfectly proper!) merely to emphasise your information: I'm usually dealing with arrays that are roughly 2000 X 30 or larger, --- Regards, Norman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Output - Results of an Array | Excel Programming | |||
| Array as output of function | Excel Programming | |||
| Array output and comment | Excel Programming | |||
| Add value to array based on if...then output in VBA | Excel Programming | |||
| Help with 1 x 2 array output | Excel Programming | |||
Threaded Mode
