IF statement for Sheet.Range.Formula

I have the following macro code set up

Please Login or Register  to view this content.

Sheet 1 is called Scripts FYI

For a few of the formulas I want to implement an IF statement, but I get an error.

For example, for range B3:B, I want the formula

Please Login or Register  to view this content.

Is there a correct way of including IF statements into the code without causing errors? Or is there a more efficient macro which can be implemented that I overlooked?

Thanks for any assistance.

Hi,

Can you please add an excel that shows what you need exactly?
I think you can use a R1C1 formula.

The macro looks right, and post also the error you have.

Thanks,
Ionut

Originally Posted by Norie

If you are trying to put that formula into a cell using code then you need to double up the quotes.

For example.

Please Login or Register  to view this content.

It was the double quotes issue, which I completely overlooked. Thank you for this!