| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring a Public variable as a Range and its lifetime
I want to store a range in a public variable that lasts as long as the
workbook is open. Will this declaration in a Module header accomplish this: Public RA as Range Sub XXX... Set RA=Range("A1") .... The scope of this variable is the project. What is its lifetime? John Wirt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
| Declaring Variables Public | Excel Programming | |||
| Declaring Variables Public | Excel Programming | |||
| declaring a public array | Excel Programming | |||
| Declaring Public Procedure | Excel Programming | |||
![John Wirt[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
