Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot record macro
Hello i am trying to record a macro with the recorder but i get a "cannot
record macro" error message. the formula i am trying to record is (this is the way it looks in excel mode) : IF(OR(E2="11 - MARKETING XXXXXXXX";E2="12 - MARKETING XXXXXXXXXX";E2="13 - INTERNATIONAL MARKETING";E2="14- XXXXXXXXXXXXX");VLOOKUP(H2;'[MARKETNGHELP.xls]vlookup'!$P:$Q;2;FALSE);VLOOKUP(E2;'[MARKEINGHELP.xls]vlookup'!$I:$J;2;FALSE)) why can't i record it? can someone give me the code to paste it directly in a module? thank you. Steven. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro and Edit Macro options disabled | New Users to Excel | |||
i need to record a macro to.... | Excel Programming | |||
how to record new macro using vba | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming |