View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default 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.