Hello,
Currently this code goes through the entire F column, but I only want it to go to F1:F900
How would I do that?
Thanks!
Currently this code goes through the entire F column, but I only want it to go to F1:F900
How would I do that?
Thanks!
VBA Code:
Sub SumColumn()
Sheets("Sales").Select
Dim Lr As Long, i As Long
Lr = Range("F" & Rows.Count).End(xlUp).Row
For i = 25 To Lr
If Range("F" & i).HasFormula() = True Then Range("F" & i).AutoFill Destination:=Range("F" & i & ":G" & i)
Next i
End Sub