Need help to define dynamic range
I'm trying to write a code to copy some formulae from a spreadsheet named "ETSFALL" from Row 2 of Column T to AG to the rest of the rows under the same column. The problem i have is that the no. of rows is dynamic (In today's data, there's 26735 rows).
I have a code in blue below that is able to copy and paste the formula to the correct no. of rows but it is taking far too much time (> 10 mins). Does anyone know of a better way of doing this??
Dim Range1 As String
Range1 = Selection.Rows.Count
Count = Selection.Rows.Count
For i = 1 To Count
Worksheets("ETSFALL").Cells(1 + i, 20).PasteSpecial