ReDim Public Variable

I need to decalre a public array and redim the arrey dimensions accroding to the final row in the spread sheet.

This is easily done with a local variable within a private sub. The problem is that the data is not reconised by the entire modual.

With the Public array declared in the global decleration, the variable is reconised by all of the sub with in the modual, how ever I am unable to ReDim it using the final Row variable.

Basically, How do I declare a Public array with using My FinalRow variable as the dimensions?

Thanks in Advanced. This forum rules!

I'm not sure what your problem is, but I hope that you find some help in here:

Please Login or Register  to view this content.

Thats what I needed! Thanks!