Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Hello,
My macro contains the following formula: With Worksheets("Entry Form").Range("K7") .Formula = "=IF(ISBLANK(J7),"",AD7)" End With When i try to run it, it gives me a run-time error (Application-defined or object-defined error). What am i doing wrong? Thanks for your help Marta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Hi
try With Worksheets("Entry Form").Range("K7") .Formula = "=IF(ISBLANK(J7),"""",AD7)" -- Regards Frank Kabel Frankfurt, Germany marta wrote: Hello, My macro contains the following formula: With Worksheets("Entry Form").Range("K7") .Formula = "=IF(ISBLANK(J7),"",AD7)" End With When i try to run it, it gives me a run-time error (Application-defined or object-defined error). What am i doing wrong? Thanks for your help Marta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
When you have embedded quotes in the formula, you must "double" them. The line
should read .Formula = "=IF(ISBLANK(J7),"""",AD7)" On Fri, 16 Jul 2004 12:56:00 -0700, "marta" wrote: Hello, My macro contains the following formula: With Worksheets("Entry Form").Range("K7") .Formula = "=IF(ISBLANK(J7),"",AD7)" End With When i try to run it, it gives me a run-time error (Application-defined or object-defined error). What am i doing wrong? Thanks for your help Marta |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
thank you!
-----Original Message----- When you have embedded quotes in the formula, you must "double" them. The line should read .Formula = "=IF(ISBLANK(J7),"""",AD7)" On Fri, 16 Jul 2004 12:56:00 -0700, "marta" wrote: Hello, My macro contains the following formula: With Worksheets("Entry Form").Range("K7") .Formula = "=IF(ISBLANK(J7),"",AD7)" End With When i try to run it, it gives me a run-time error (Application-defined or object-defined error). What am i doing wrong? Thanks for your help Marta . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |