I'm brand new at
VB, so my problem-solving abilties are rather
limited...
I have 4 public variables that I have defined in the "Declarations"
area of Module1. Within Module1, I have a bunch of macros that use
these public variables. The 4 variables could be considered
"constant", in that I don't want them to change from macro to macro.
The error I get is "Compile Error - invalid outside procedure", and it
shows up when I try to set the first public variable. My public
variable code is below. Any help is greatly appreciated...
_____________________________________
Public iRange As Range
Public QU, PS, PM As Worksheet
Set QU = Sheets("Questionnaire")
Set PS = Sheets("Process Summary")
Set PM = Sheets("Process Methodology")
Set iRange = PS.Range("A6:T26")
_____________________________________
--
clmarquez
------------------------------------------------------------------------
clmarquez's Profile:
http://www.excelforum.com/member.php...o&userid=29386
View this thread:
http://www.excelforum.com/showthread...hreadid=501145