| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mutliply a worksheet by a constant | Excel Discussion (Misc queries) | |||
| Creating a row that is constant and updatable across all worksheet | Excel Discussion (Misc queries) | |||
| If in specific cell in any worksheet but worksheet one add to spec | Excel Worksheet Functions | |||
| Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
| hyperlink to a specific worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
