I am trying to copy/paste a line of data from one worksheet to another. The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data to.
IE: keyword "next" moves the pointer to the cell to the right, I need to move
the cell down. The keyword "end(x1down)" moves the pointer down half page or
to the end of page.

"hecfrme" wrote:

> want to edit a macro to better meet my needs. Can't locate the keywords
>