M
Mike K
Oh Wise Ones,
I have a sheet that inserts a row and formats some cells including this line
that works:
Worksheets("Open Red Tags").Range("Q4").Formula = "=IF(J4=$K$1,H4,"""")"
but when I tried to format R4 like below I get an error as soon as I enter it:
Unexpected end of statement
Worksheets("Open Red Tags").Range("R4").Formula = "=IF(F4="A",H4,"""")"
Then I tried this that didn't work:
Worksheets("Open Red Tags").Range("R4").Formula = "=IF(F4=A,H4,"""")"
What am I doing wrong? They seem so similar.
Mike
I have a sheet that inserts a row and formats some cells including this line
that works:
Worksheets("Open Red Tags").Range("Q4").Formula = "=IF(J4=$K$1,H4,"""")"
but when I tried to format R4 like below I get an error as soon as I enter it:
Unexpected end of statement
Worksheets("Open Red Tags").Range("R4").Formula = "=IF(F4="A",H4,"""")"
Then I tried this that didn't work:
Worksheets("Open Red Tags").Range("R4").Formula = "=IF(F4=A,H4,"""")"
What am I doing wrong? They seem so similar.
Mike