Past formula to the end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have spreadsheet that changes in row size and want to copy formula from column K2 and past the formula to the last row. Despite sometimes it ends at 1303 or 1500
Thanks
D
 
Thanks, got it to work
Dim LastRow As Lon
Dim LastCol As Lon
Dim rng As Rang

With ActiveShee
Set rng = .UsedRange 'try to reset lastused cel
With rn
LastRow = .Rows(.Rows.Count).Ro
LastCol = .Columns(.Columns.Count).Colum
End Wit

.Range("K2").AutoFill
Destination:=.Range("K2:K" & LastRow), Type:=xlFillDefaul

End Wit
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro will copy formula instead of value 6
Paste in column B using Last row of either column B, C or D. 10
Column number of last column that returns value ignore formulas 8
Copy Formula Down until last row 2
Excel Help to copy information from one row at a time to another sheet 1
End process at last row of data 3
Pasting formula in every nth row 3
Mid column sum formulas with varied ranges to sum 17

Back
Top