Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hope someonde is smart enough?!?!
If you are confident that there are no other errors in
your code, then the easiest way is to add the following lines at the top and bottom of your code: On error resume next ... your code here... On error goto 0 What this does is force VBA to advance to and execute the next line of code any time an error is generated, so it will circumvent the problem with invalid "Find"s. The line at the end simply re-enables errors. As I said at the start, make sure the rest of the code the Find statements trigger works the way you want before adding this or all kinds of strange things might happen and you wont know why!! Cheers, Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation I Hope | Excel Worksheet Functions | |||
Simple one I hope???? | Excel Discussion (Misc queries) | |||
Hope someone can help me | Excel Discussion (Misc queries) | |||
Hope someone here can help me | Excel Discussion (Misc queries) | |||
An easy one i hope | Excel Discussion (Misc queries) |