| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula error query
Hi All,
I'm looking for a VBA help if there is a cell with "#DIV0!" error. How can I track it down and jump over this cell? I treid Application.WorksheetFunction.IfError but couldn't figure how to use it. Thanks a lot. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula error query
You could use this, but it would skip over any cells with errors, not
just the division by zero errors. If WorksheetFunction.IsError(ActiveCell) Then MsgBox "Error" End If Lp12 wrote: Hi All, I'm looking for a VBA help if there is a cell with "#DIV0!" error. How can I track it down and jump over this cell? I treid Application.WorksheetFunction.IfError but couldn't figure how to use it. Thanks a lot. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| web query error | Excel Discussion (Misc queries) | |||
| MS Query error | Excel Worksheet Functions | |||
| MS query error | Excel Discussion (Misc queries) | |||
| error using MS query | Excel Discussion (Misc queries) | |||
| Run-query error | Excel Programming | |||
Hybrid Mode
