I've written the following code for a form I'm using. I'm using the find statement to locate information in a selection, but when it doesn't find it, the program errors and closes. I've tried many different things and nothing is working. I am thinking it has something to do with the What:=Volts.Text section.
Please Login or Register to view this content.
Hi, hockeyadc,
set a range to the cell if a value is found and check for the range like
I woud avoid the use of ActiveCell in a macro if I can.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks