I currently have this:
Dim lastrow As Long
Dim lastcol As Long
Sheets("Template").Select
Range("v13").Select
lastrow = Range("S" & Rows.Count).End(xlUp).Row
lastcol = Range(11, Columns.Count).End(xlToLeft).Column
Range("V13").Formula = "FORMULA HERE"
Range("V13").AutoFill Destination:=Range("V13:V" & lastrow)
Range("V13:V" & lastrow).Select
ActiveSheet.AutoFilterMode = False
End Sub
I have to autofill the formula right to a specific column.
The end goal is to autofill a matrix: down to the last row, then to a specific column. The part I am stuck on is autofilling the formula to the right with "Range("V13:V" & lastrow).Select"
Thanks guys!
Dim lastrow As Long
Dim lastcol As Long
Sheets("Template").Select
Range("v13").Select
lastrow = Range("S" & Rows.Count).End(xlUp).Row
lastcol = Range(11, Columns.Count).End(xlToLeft).Column
Range("V13").Formula = "FORMULA HERE"
Range("V13").AutoFill Destination:=Range("V13:V" & lastrow)
Range("V13:V" & lastrow).Select
ActiveSheet.AutoFilterMode = False
End Sub
I have to autofill the formula right to a specific column.
The end goal is to autofill a matrix: down to the last row, then to a specific column. The part I am stuck on is autofilling the formula to the right with "Range("V13:V" & lastrow).Select"
Thanks guys!