Copy formula to end? Macro

[MCosca]

This is probably so simple and I apologize in advance for not being able to locate the precise reply to my problem as I have searched for this.

I have formulas in K2 & L2 that I need to copy to the end of the columns each month in my spreadsheet. Since it is a monthly spreadsheet the amount of rows differs each month. The way I have it written currently it is taking an extremely long time to copy the formulas down to the end of the data. There is data in column N, O, etc.

How do I copy this formula to the end of the current data each month?

Here is the VB info - I need this to go from K2:L (end of current data)

Range("K2:L2").Select
Selection.AutoFill Destination:=Range("K2:L32748")
Range("K2:L32748").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

 

[Fluff]

Which column can be used to determine the last row of data?

 

[MCosca]

Which column can be used to determine the last row of data?

Column A or B or C (not sure if it matters for the column to be adjacent to K or L or not)

Thank you so much - I feel silly asking because its going to look like it was so easy to fix after Im shown the means to do so

 

[Fluff]

Ok, how about

   With Range("K2:L" & Range("A" & Rows.count).End(xlUp).Row)
      .FillDown
      .Value = .Value
   End With

 

[MCosca]

look like that solves the issue! Thank you again, I really appreciate the helpful folks here on this site as you all have bailed me out of some jams over the years!

 

[Fluff]

You're welcome & thanks for the feedback.