Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting error 1004 trying to write formula in cell
In a macro, I wanted to be able to update a formula. I manually updated the
formula on the sheet and it works fine. I simply copied the formula from the sheet and put it in quotes see below, but I get an error "Application-defined or object-defined error" Sheets("test").Range("A1").Formula = "=IF(ISERROR(VLOOKUP($AE6,'Change Report 6.0'!$C$20:$G$61,AG$4,FALSE)),"",VLOOKUP($AE6,'Cha nge Report 6.0'!$C$20:$G$61,AG$4,FALSE))" The Help on the error seems to suggest I tried to cause an error, clearly this is not my intention. Any ideas? -- Trefor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
How to write a formula that will prevent appearance ERROR MESSAGE | Excel Worksheet Functions | |||
Protect Sheet but enable cell ranges giving Error 1004 Unable to set | Excel Programming | |||
Error when using macro to write formula to cell | Excel Programming | |||
Excel Formula - Error 1004 - Bug? Mistake? | Excel Programming |