Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset Variables
Excel 2002, WinXP
I have a number of Public range variables that I need to set using the Find command. I need to trap the error if the search item cannot be found. To do this I want to set all the range variables to Nothing to begin with because each variable may have a range from the last time the code was run. This is similar to clicking on the Reset button in the VBE. Question: How do I code the Reset? Thanks for your help. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Key reset | Excel Worksheet Functions | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
How do I reset the tab key? | Excel Discussion (Misc queries) | |||
reset to zero | Excel Worksheet Functions | |||
Glolbal Variables Reset when using OleObjects | Excel Programming |