Excell2000 Macro 1

[rlindey]

i WANT TO ADD A SECTION TO A PREEXISITNG MACR THAT WILL ADD THE FORMULA "IF(ISBLANK(A8),"", "STRING"".
I HAVE TRIED VARIOUS ENTRIES SIMILAR "ActiveCell.FormulaR1C1 = _ "IF(ISBLANK(RC[-7],"","TEXT&quot"
WHEN I PRESS ENTER TO ADD ANOTHEROROWS Ii KEEP GETTING AN ERROR MESSAGES.
HOW DO I ENTER THE CORRECT COMMAND?

BOB

 

[dsi]

Your problem lies in the quotation marks. They are seen as the start/end of a string instead part of your string variable. Your best bet would be to put the string into a varaible first.

Dim sEqn As String

sEqn = "=IF(ISBLANK(RC[-7]," & _        
       Chr(34) & Chr(34) & "," & _
       Chr(34) & "TEXT" & Chr(34) & ")"

ActiveCell.FormulaR1C1 = sEqn