help writing formula

[Ryan Proudfit]

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

[Chip Pearson]

To include a " character in a VBA string, use two " characters.
E.g.,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ryan Proudfit" <RyanProudfit@discussions.microsoft.com> wrote in
message
news:A8D7714B-372E-4233-8B75-E924207FFBF7@microsoft.com...
> 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