Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a single dimension array DataHolder(CellCount) where CellCount =
the number of items in the array. I want to write the entire contents of the array to C1002 to Cxxxx on the active sheet where xxxx depends on the length of the array. I have tried Range(Cells(1002, 3), Cells(1002 + cellcount, 3)) = DataHolder but it writes the only value at DataHolder(1) in every cell instead of all the values in the array. What am I doing wrong? Thanks, Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multi dimension/axis single series bar chart | Charts and Charting in Excel | |||
Array transfer - 1 dimension v. 2 dimension | Excel Programming | |||
writing array into excel sheet | Excel Programming | |||
single dimension array | Excel Programming | |||
Placing an array on the active sheet | Excel Programming |