You might look into declaring a public constant, but might be an issue with a
sheet.
to avoid issues I might use a string constant then adjust other code.

Const QU As String = "Questionnaire"


"clmarquez" wrote:


Thanks guys. I understand now. I just thought that if these were going
to be set to the same thing, that I could somehow "globally" set them,
and not worry about having to re-set them in each individual macro.

Instead of setting them in each individual macro, could they somehow be
"globally" set once somewhere else outside of public declarations?
Maybe in Workbook or something? Or, do you advise against it?


--
clmarquez
------------------------------------------------------------------------
clmarquez's Profile: http://www.excelforum.com/member.php...o&userid=29386
View this thread: http://www.excelforum.com/showthread...hreadid=501145