| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set objects at module level?
I have a module with several Subs. All the Subs will refer to the
same objects. I know how to Dim the object references at the top of the module, but then I have to Set them in each Sub. Is there a way to set workbook, worksheet and range objects for the entire module? Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign Value to Module Level Variable | Excel Programming | |||
| use of module level variables | Excel Programming | |||
| Declaring array constants at module level | Excel Programming | |||
| referencing at module level | Excel Programming | |||
| module-level variable lifetime | Excel Programming | |||
Threaded Mode
