Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have an array 'Static runner()' which I redim when code calls
for it. 'redim runner(1 to 1, 1 to idex)'. Idex is a counter. The arrays perfect, does everthing I want it to, but I cant seem to figure out this. (Im sure Ive asked before but cant find the reply). If my array has 100 values, how do I send just the last 30 values to the worksheet. Im using Range("o1").Resize(UBound(Runner, 2), 1) = Application.Transpose(Runner), but this adds all values. Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
Use array to return array of values | Excel Worksheet Functions | |||
Print Array for hidden sheets using VBA | Excel Programming | |||
Convert values in a variant array to integer values | Excel Programming | |||
Print Array in Cell | Excel Programming |