0

I'm pasting data from multiple worksheets into one consolidated data tab and I want the macro to find the bottom of the data to know where I need it pasted. What function do I use instead of Range to accomplish this? I have little experience editing macro's, so the macro was writen by recording what I want it to do.

I was using the Ctrl shift down function to identify the bottom of the data set where I want it pasted but it looks like the macro won't adjust when there are more lines of data (Range A8626). What command shoudl I use instead?

Range("A2").Select
        Range(Selection, Selection.End(xlDown)).Select
        ActiveWindow.SmallScroll Down:=9
        Range("A8626").Select
        ActiveSheet.Paste
BigBen
  • 46,229
  • 7
  • 24
  • 40
Kyle Wynette
  • 1
  • `Dim lastRow As Long`, `lastRow = Range("A" & Rows.Count).End(xlUp).Row`, `Range("A" & lastRow + 1).PasteSpecial xlPasteAll`. – BigBen Jun 15 '23 at 13:03

0 Answers0