IF formula is used in Macro, Get If ranges value from Cell.

[motilulla]

Using Excel 2010
Hello,

The following formula I am using in Macro which work fine, I want help does it is possible in to formula IF where is C6 get value row 6 from cell S2 & C14 get value row 14 from cell S3

Range("S6:AF50).Formula = "=IF(C6=C14,""A"",""B"")"

Regards,
Moti

 

[Joe4]

Try this:

Range("S6:AF50").Formula = "=IF(C" & Range("S2") & "=C" & Range("S3") & ",""A"",""B"")"

 

[Joe4]

You are welcome!

The key to remember is that you are combining literal string values and values from ranges (or variables).
You enclose literal text pieces in double-quotes, and range references and variables must NOT be enclosed in double quotes, and they are all combined with "&".

 

[motilulla]

Try this:

Range("S6:AF50").Formula = "=IF(C" & Range("S2") & "=C" & Range("S3") & ",""A"",""B"")"

Joe4, operated fine! Thank you for your time and help. Good Luck.

Regards,
Moti