I've done that and the problem is: macro assigns a specific line # and when
I repeat the macro it pastes over the last entry. Somehow I need to tell the
macro routine to move down 1 line.

"Myrna Larson" wrote:

I would turn on the macro recorder, then carry out the steps manually. Look at
the generated code to learn the commands needed.


On Sat, 24 Sep 2005 14:11:02 -0700, "hecfrme"
wrote:

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