The current formula residing in about 200 cells is

='Daily N '!AN13

I'm trying to write a macro that will change that formula to

=IF(OR(B9=6,B9=7),"",'Daily N '!AN13)

Here is my code

ActiveCell.Formula = "=IF(OR(B" & ActiveCell.Row & "=6,B" & ActiveCell.Row &
"=7),""," & strHoldFormula & ")"

My problem is

"=7),"","

Since quotes are used to identify the beginning and end of a text string
within a formula, how do you use quotes within a formula to tell Excel to
display nothing if a condition is true?

--
Ryan Proudfit