specific worksheet can't be constant?
I have a series of worksheets in a workbook and a slew of macros that
work with them. One particular worksheet is used in all the macros.
I've looked around here and in Walkenbach, but can't find a way to
declare that worksheet name a Public variable or constant. It appears I
will have to start each macro with:
Set CtyExtr = ActiveWorkbook.Sheets("County Extract")
Is there a way to do this project wide?
Thanks for your help.
|