ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reset Variables (https://www.excelbanter.com/excel-programming/303581-reset-variables.html)

Otto Moehrbach[_6_]

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




All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com