Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modification of Recorded Macro
If I am in the wrong newsgroup I apologize. Maybe someone can direct me to
the correct group. I have an excel workbook with one column of data on sheet 1. I have recorded a Macro that moves certain data from sheet 1 to specified columns on sheet 2 of the workbook . In some cases I needed to record several "find" i.e. EDIT-Find to locate on sheet 1 the information I need to move to sheet 2. My problem occurs certain months when the "find" does not locate the data I am searching for. If I was doing this manually, I would set a default value in the appropriate column of sheet 2 and continue. However when my macro runs and encounters this situation I receive a runtime error message and of course the Macro halts. My question is can I : 1. Detect the runtime error before stopping execution of the Macro by adding code to my Macro 2. Put a default value in the required column of sheet 2 3. Continue with the Macro at the point I received the runtime error I am new at Macros and VBA. Thank you in advance for your assistance. Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Modification in Recorded Macro | Excel Programming | |||
Recorded single column insert in macro. Macro inserts two not one | Excel Programming | |||
How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming |