Define a Formula in VBA

[santosh226001]

Hello
How can i add following formula in VBA form
'=IF(Q327="SP",IF(OR(T327="MLC",T327="mp"),R327&T327&"Others",H327),R327&"Others")

When ever i apply a formula in VBA in following type..

Please Login or Register  to view this content.

i m confuse that how can i use " & Cells(r.Row, "<Colum Value>").Address & " code line in above mention formula pls suggest me

We want to use this formula in Column S

Thanks in advance

[santosh226001]

My existing code is following we want to add

Please Login or Register  to view this content.

We want to add this formula to below red color code line
=IF(Q327="SP",IF(OR(T327="MLC",T327="mp"),R327&T327&"Others",H327),R327&"Others")

pls help

[santosh226001]

We got solved with self try, forum other thread help with following

Please Login or Register  to view this content.