Check out.
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm

--
Jacob (MVP - Excel)


"sarndt" wrote:

If i have a variable that I want to set and use from TheWorkbook, a number of
difference worksheets, a module, and a class module, which General
Declarative section do I put it in, and do I reference it as a Public
Variable or something else.

Thanks

Steve