Hello all,

I want to create a dynamic array in visual basic for excel. Somehow I am
doing something wrong with the following code.


dim my_array as double
dim my_integer as integer

my_integer = 3
redim my_array(my_integer) as double



this code doesn't seem to work in excel 97. Does anybody have an idea
how this should be done? The value of the variable my_integer is not
known at the start of the program.

thanks in advance,
Koos