Thread: Reset Variables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default 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