MACRO FORMULA HELP

[rikvny02]

Can someone help me to understand why entering a formula this way does not work

Range("K5").Select
ActiveCell.Formula2R1C1 = "=IF(LIST!B2="",1,LIST!B2)"

but, entering this way does.

Range("T5").Select
ActiveCell.FormulaR1C1 = "=IF(list!R[6]C[-18]="""",10,list!R[6]C[-18])"

 

[Joe4]

If you are entering the exact range in non-R1C1 format (like your first one), get rid of the "R1C1" part.
You also need to double-up the double-quotes part.
You can also combine the two rows to just this:

Range("K5").Formula = "=IF(LIST!B2="""",1,LIST!B2)"

 

[MARK858]

You need to double the quotes, one set is what appears in the cell, the other tells VBA that it is text

Range("K5").Formula2 = "=IF(LIST!B2="""",1,LIST!B2)"

Edit: oops Joe beat me to it and mentioned the R1C1

 

[rikvny02]

If you are entering the exact range in non-R1C1 format (like your first one), get rid of the "R1C1" part.
You also need to double-up the double-quotes part.
You can also combine the two rows to just this:

Range("K5").Formula = "=IF(LIST!B2="""",1,LIST!B2)"

THANK YOU.

 

[Joe4]

You are welcome.
Glad we were able to help!