Global/Static Variables

[matthewh]

How do I decare a Global variable that will be available to the entire workbook as a static. I need to procuce a lot of the same sheet with 2 name changes on each one, but the names are used throughout the code. It's easier to change 2 variables than go through the code and do it that way.

 

[Dave Hawley]

Hi

At the very top of standard module use:


Public Const MyNum As Integer = 256

 

[Juan Pablo González]

Dave "teaches" how to add a public constant, but if you need a variable, use this:

Public MyNum As Integer

That will be available to all modules