Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA using an array
I have an array Array(100)
and I want to set Array() = 10 for 1-100 Is there another way to set = 10 rather then using For i = 1 to 100 Array(i) = 10 Next I Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA using an array
Not really. But why worry? Even if that loop went to 100000 it'd be a
fraction of a second! "Jeff" wrote in message ... I have an array Array(100) and I want to set Array() = 10 for 1-100 Is there another way to set = 10 rather then using For i = 1 to 100 Array(i) = 10 Next I Thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA using an array
There are other ways, but probably all less efficient that that loop.
The loop is pretty fast. In article , "Jeff" wrote: I have an array Array(100) and I want to set Array() = 10 for 1-100 Is there another way to set = 10 rather then using For i = 1 to 100 Array(i) = 10 Next I Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |