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

[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?

 

[Mike H]

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.