Hi Everyone!

I have a problem that involves cell referencing while executing a formula, i have two codes below, both are performing the same thing, however, the second one is not "iterating" which is because of the referencing. To provide background, in the second code, I'm referencing a specific sheet since the data I'm working on is being copied from one sheet to another. I'm not sure how to correct it though and any advice would be much appreciated.

1st Code:
    'Loops until no data on previous column
    Do
    ActiveCell.FormulaR1C1 = "=RC7-0.5"
    ActiveCell.Offset(1, 0).Select
    Loop Until IsEmpty(ActiveCell.Offset(0, -1))
2nd Code: 
    'Performs formula after copy
    Do
    ActiveCell.Formula = "=Data2!$T2-0.5"
    ActiveCell.Offset(1, 0).Select
    Loop Until IsEmpty(ActiveCell.Offset(0, -1))