Select a Range with reference to other range which has values always

From this VBA code, you can define your range for which you need to update a formula or a value..

TmpR = Range("R" & Rows.Count).End(xlUp).Row
Range("T2:T" & TmpR).Select

Here, iam updating a formula to show up a ABS value in the selection and paste only Values:

Selection.FormulaR1C1 = "=ABS(RC[-4])"
'FOR PASTE SPECIAL VALUES
Selection.Value = Selection.Value