where do i find a list of macro keywords

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

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
>

here's a simple routine you can possibly adapt to your situation. not sure
where your data is actually located, so i just used a1 thru e1 in my
example



Option Explicit

Dim lastrow As Long
Sub copydata()
lastrow = Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1,
0).Row

Range("A1:E1").Copy Sheets("Sheet2").Range("A" & lastrow)
End Sub

--


Gary


"hecfrme" <hecfrme@discussions.microsoft.com> wrote in message
news:B5622EAF-5C6A-401C-9E80-A01FFBD6A30D@microsoft.com...
>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
>>

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"
<hecfrme@discussions.microsoft.com> 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
>>

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"
> <hecfrme@discussions.microsoft.com> 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
> >>
>

activeCell.offset(1,0).Select
--
Regards,
Tom Ogilvy

"hecfrme" <hecfrme@discussions.microsoft.com> wrote in message
news:E418900D-3207-4F4C-905E-7D5A6A84BBD6@microsoft.com...
> 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"
> > <hecfrme@discussions.microsoft.com> 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
> > >>
> >