Thread: array question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent Brent is offline
external usenet poster
 
Posts: 109
Default array question

Want to do something like:

arrayvar = ("alpha","beta","delta")
For B = A(1) to A(3)
.......

Is this possible? Or do I have to do:
arrayvar = ("alpha","beta","delta")
For count = 1 to 3
B = A(count)

Also, for 3 variables, is this method faster than a if then else procedure?
Thank you.

Brent