Hi
have a look at 'ReDim' in the Exel VBA help for this

-----Original Message-----
Hi all,

In my Excel VBA program, I have to define an array,
but the dimension of
this array is a variable, which dependents on the value
in cell B1. I think
this is an easy problem but I don't know how to solve it
_<

Thanks very much for your help!!

Best wishes
C.F. Yiu


.