Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Public Password | Excel Discussion (Misc queries) | |||
Dim vs. Public | Excel Programming | |||
Public declaration | Excel Programming | |||
public sub | Excel Programming | |||
Public Sub Help | Excel Programming |