How do I make a macro seek the botom of a list?

  • Thread starter Thread starter chads_vstream
  • Start date Start date
C

chads_vstream

I'm trying to copy data from a file and paste it at the bottom of other data
using a macro. manually, i would copy the selection toggle to my other open
sheet, press CTRL <down> to jump to the bottom of the data and then paste.
when i try this in a macro it always jumps to a specific cell rather than a
relitive one. anyone know how to rewrite the VB code to make this relitive?
 
Hi,

In a macro this would find the last used cell in colum A of the active sheet

LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row

So we add 1 to that to get the empty cell below

LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row+1

And to turn that into a range to paste into we could use

Range("A" & Lastrow).pastespecial

or whatever type of paste you want to do
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top