| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How long do variables retain their values
say I have a variable called "RowNum"
RowNum is being used in sub Add_Sheets. halfway through Add_Sheets the code calls sub Hide_Rows. there's more code after Add_Sheets calls Hide_Rows. Hide_Rows also uses a variable called RowNum. In Add_Sheets RowNum = 98, but in Hide_Rows RowNum=10. When Excel finishes Hide_Rows and returns to Add_Sheets, will RowNum still be 98? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Rows using Long Variables | Excel Discussion (Misc queries) | |||
| VBA - Delete Drop Down, Retain Values | Excel Programming | |||
| Add two cell values, retain it, and add another value | Excel Worksheet Functions | |||
| Retain values of combo box | Excel Programming | |||
| Declaring variables (Long, String, Integer) and interpretation spe | Excel Programming | |||
Threaded Mode
