Autofill Formula To Specific Column

[temerson]

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!

 

[Fluff]

How about

Sub temerson()
   Dim lastrow As Long
   Dim lastcol As Long
   
   lastrow = Range("S" & Rows.Count).End(xlUp).Row
   lastcol = Cells(11, Columns.Count).End(xlToLeft).Column
   Range("V13", Cells(lastrow, lastcol)).Formula = "your formula"
End Sub

 

[temerson]

This is perfect!!!! THANK YOU!

 

[Fluff]

You're welcome & thanks for the feedback