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
Regards,
Moti
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
VBA Code:
Range("S6:AF50).Formula = "=IF(C6=C14,""A"",""B"")"
Regards,
Moti