View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Kruger J Kruger is offline
external usenet poster
 
Posts: 2
Default Create dynamic variable names?

Hi,

I have been looking everywhere on how to create dynamic variables in excel.
I want the same result as what the eval() function in JavaScript gives. ie.

a1 = new Array(10);
a1[0] = "hello";
alert(eval("a" + 1)[0]);

or

for(i = 0; i <=10; i++){
eval("a"+i) = i;}

Any help would be appreciated.