Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Error does not appear to get directed to the OnError code.
Hi
We are having a problem with error trapping in Excel. We have code which says On Error goto xyz, which looks for a specific error and deals with it. It then returns back to the code where it trapped the error. We expect to see this error multiple times in the code execution. The code being used is something like: set myCell = Cells(i,j) on error goto xyz sMyString = myCell.Formula Not all cells have formulas and so it throws an error sometimes, and that's fine by us [we are trying to find the cells with formulas] The first time it throws an error on the sMyString line it correctly goes to our error label xyz and then gets returned back into the loop. However the 2nd time it throws an error it pops up the error box rather than jumping to the error handling code again. Can someone shed some light? Thanks Andy C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros Being Re-Directed | Excel Programming | |||
OnError - what generated the error? | Excel Programming | |||
How to trap an error with onError in a for i loop | Excel Programming | |||
Programming a Directed Flow Chart | Excel Programming | |||
User directed graphing? | Excel Programming |