Global variable out of context

[labogola]

I have a variable which changes every time the worksheet opens. I declare it as public so that it can be passed to a procedure.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

For some reason I can't get the count of the columns into the public variable. The watch shows it as being "out of context" and then my procedure does not work properly.


Any ideas?