Formula for one Row Ok. but for range require syntax

[SamDsouza]

Hello
if my formula looks like this

With ws
.Range("CU" & curRow).Formula = "=CT" & curRow & "-CI" & curRow & "-CJ" & curRow
End With

then how can i Represent the above with below range

With ws
.Range("CU3" & ":CU" & lastRow).Formula = [COLOR=#ff0000][B]"=CT3" & ":CT" & lastRow & "-CI3" & ":-CI" & lastRow & "-CJ3" & ":-CJ" & lastRow[/B][/COLOR]

'Marked in red gave error

End With

Thanks
Samd

 

[RoryA]

Just use the formula as it would be in the first row:

Ws.Range("CU3:CU" & lastRow).Formula = "=CT3-CI3-CJ3"

 

[SamDsouza]

RoryA thanks for immediate response

Code:
Ws.Range("CU3:CU" & lastRow).Formula = "=CT3-CI3-CJ3"

with the above syntax you provided. Will the values be same for full range or will it update.
Will yours update CT4- CI4-CJ4
CT5-CI5-CJ5

 

[RoryA]

It updates just as if you did it manually. Quicker to try it...

 

[SamDsouza]

Yes Tried : Great

I thought i might have to put For Next Loop for what i wanted. But you saved me from looping.
Real Amazing

Thank you so much
SamD

 

[RoryA]

Glad to help.