Public Declerations
I have a VBA Module named MasterFormulas. In it will be several
sub-routines. The first one starts like this:
Option Explicit
Public Sub MRR()
'Begin General Declerations
Dim WSDSD As Worksheet
Set WSDSD = Worksheets("Data SD")
Dim WSRep As Worksheet
Set WSRep = Worksheets("Report")
Dim WSCri As Worksheet
In every sub-routine in the module MasterFormulas, I want Excel to remember
these declerations. How can I avoid having to re-declare these in every
sub-routine?
--
Thanks
Shawn
|