definig a 3d array of unknown size

[nschessnerd]

Hey i am trying to make a 3 dimensional string array, and i wont know the size of it until the user enters the three numbers. I need to declare the variable as private or else i will have to pass it everywhere. Are there any alternatives or how would i do this?
thanks
m

[DenisOxon]

Hi,

Have you tried redim option.

If you dimension variable at start e.g dim f(1,1,1)

Then when user has entered data redim f(x,y,z) where x,y,z are values entered by user.

This should work based on what you have said.

Denis

[nschessnerd]

Ahh thanks works great!