global variables
 

How can I set the default value of a global variable?

global variables
 

You can initialize a constant:

Const Myvar As Long = 6

but for a variable, you would need to run a procedure to initialize it.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
How can I set the default value of a global variable?

global variables
 

yar! oh well thanks!

global variables
 

Intitilize the variable in the Workbook open procedure... Then it will be
intialized from the moment the sheet is opened...
--
HTH...

Jim Thomlinson


" wrote:

yar! oh well thanks!