| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recording macro for a formula
I've created the following formula on a worksheet that works properly but
when I try to record a macro to create the formula in visual basic editor it doesn't would. I get an error "unable to record". Can anyone help me with this? =IF(ISERROR(IF(ISERROR(VLOOKUP(TRIM(A2),Sheet3!A:D ,4,FALSE)),VLOOKUP(TRIM(A2),Sheet1!A:C,3,FALSE),(V LOOKUP(TRIM(A2),Sheet3!A:D,4,FALSE)))),"WE DON'T HAVE A START DATE IN OUR SYSTEMS",IF(ISERROR(VLOOKUP(TRIM(A2),Sheet3!A:D,4, FALSE)),VLOOKUP(TRIM(A2),Sheet1!A:C,3,FALSE),VLOOK UP(TRIM(A2),Sheet3!A:D,4,FALSE))) -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording a Macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
| recording macro to paste a copied ws formula | Excel Programming | |||
Threaded Mode
