Thread: variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
 
Posts: 28
Default variable

Hi,
I would think you need to place the xmean variables in an array i.e dim
xmean(1 to 20)

They can then be referenced in a loop with xmean(i), i being the loop
variable.

Don

wrote in message
ups.com...
Hi, Ive got 20 variables named xmean1, xmean2,
xmean3............xmean20. I want to refer to these with, For I = 1 TO
20. Ive tried, xmean(i), xmean & i and (xmean(i)). Any idea on how to
do this, or is this not possible.
Regards Robert