Macro to Reset formulas in a column

[HJSmith]

Hi all,

I'm new to VBA so trying to learn as much as I can but I'm stuck on this one.
I'm trying to create a macro that when the appropriate button is pressed, resets the formulas in a column that have been overtyped.
I can do this for a single cell, though I want to create one that performs along the lines of:
T5 = I5 - J5
T6 = I6 - J6
T7 = I7 - J7....

and so on.

Any help is vastly appreciated
Regards
H

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub HJSmith()
   Range("T5", Range("T" & Rows.Count).End(xlUp)).FormulaR1C1 = "=rc[-11]-rc[-10]"
End Sub

 

[HJSmith]

Hi & welcome to MrExcel.
How about

Sub HJSmith()
   Range("T5", Range("T" & Rows.Count).End(xlUp)).FormulaR1C1 = "=rc[-11]-rc[-10]"
End Sub

Thank you for the welcome and the prompt reply.
That worked perfectly, thank you!

 

[Fluff]

Glad to help & thanks for the feedback.