hi ninja's
please explain me that how can I apply one specific formula in selected range I sheet using VBA.i am new to vba please provide sample code please.
example:: If [a1]+[b1]>5 then write text "ok" in range("c1:c20").
please help me.
please also provide if I want corresponding results I.e.( a1+b1)>5 then c1=ok
if (a2+b2)>5 then c2=ok
etc..
please explain me that how can I apply one specific formula in selected range I sheet using VBA.i am new to vba please provide sample code please.
example:: If [a1]+[b1]>5 then write text "ok" in range("c1:c20").
please help me.
please also provide if I want corresponding results I.e.( a1+b1)>5 then c1=ok
if (a2+b2)>5 then c2=ok
etc..
Last edited: