Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
public declaration
Hi
I am writting several modules. The modules refer to a lot of the same spreadsheets within a single workbook. For each module I have been declaring the different sheets. for instance Dim wsMe as worksheet set wsMe = thisworkbook.worksheets("Me") Basically I am repeting the code in every module Can I declare things like this just once and then not have to include it in every module Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Workbook Declaration | Excel Discussion (Misc queries) | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
Correct declaration of variables | Excel Programming | |||
Variable Declaration?? | Excel Programming |