View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff
 
Posts: n/a
Default 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