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
|