![]() |
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