Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have recorded a Macro and I am modifying it(easiest way for me to learn).
However I have run into a situation I can not find a solution in any documentation. Basically I have series of "cells.find" in sheet 1 of a workbook followed by a copy and paste to sheet 2 in the workbook. All is well if I find all the information I am trying to find with the cells.find. Before each "cells.find" I have inserted a statement "On Error goto Label1" or Label2, etc. Basically I am skipping the copy and paste and looking for the next information I need with the next "cells.find" . The first time I perform a "cells.find" and do not find the required information I branch correctly to the next part of the macro that does another "cells.find". If I encounter another error condition the macro does not take the branch to On Error GoTo Label20. It generates a run time error (91). I have added "err.Clear" and "On Error GoTo 0" but I still get a runtime error on the second failure of the "cells.find". I can not get the Macro to reset the "On Error GoTo Labeln". Does anyone have any suggestions on how to remedy this situation. I believe there may be some Pure VB solutions but I don't think I am ready to tackle them yet when I can't even get this "dumb" macro to work. Thank you in advance for your assistance. Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a Error Handling for this Macro | Excel Discussion (Misc queries) | |||
Error Handling Problem calling Macro from Other Worksheet | Excel Programming | |||
Error handling in macro | Excel Discussion (Misc queries) | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming |