| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to continue macro if there is an error value
I have a macro which replaces the file name in a formula. Sometimes the new
file name does not yet exist and the "Update Value.." box pops up. I hit CANCEL and the macro continues. Is there a line of code which will cause the macro to hit cancel and continue without any input from me. I came across the following code but don't know what to put after THEN If IsError(ActiveCell.Value) Then Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to continue macro if there is an error value
You can use Dir to check if the file exist before you replace the value in the formula
If Dir(FileCell.Value) < "" Then -- Regards Ron de Bruin http://www.rondebruin.nl "msdrolf" wrote in message ... I have a macro which replaces the file name in a formula. Sometimes the new file name does not yet exist and the "Update Value.." box pops up. I hit CANCEL and the macro continues. Is there a line of code which will cause the macro to hit cancel and continue without any input from me. I came across the following code but don't know what to put after THEN If IsError(ActiveCell.Value) Then Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB code to continue macro | Excel Discussion (Misc queries) | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
| open workbook from a macro and continue this macro afterwards | Excel Programming | |||
| VBA codes for macro to continue | Excel Programming | |||
| The way to continue do macro recording | Excel Programming | |||
Linear Mode
