hi David

Look here
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"David Vollmer" <DavidVollmer@discussions.microsoft.com> wrote in message news:F1AFB43E-07FB-4BB9-8846-C51AF2AD600D@microsoft.com...
>I want to include code in a macro that will allow me to move the cursor from
> one cell to another. For example, if the cursor is in a cell and I want to
> move it down one row, what is the code. The cell that the cursor is in will
> vary and will typically be the first blank cell at the bottom of the sheet.
>
> What I am doing is copying rows from one sheet to another. I select the rows
> from one sheet and then run the macro. I want the macro to goto the other
> sheet, find the first blank row, paste the rows from the original sheet and
> return to the original sheet in order for me to select the next number of
> rows to copy.
>
> The actual macro I need is more sophisticated than what I am describing, but
> for now knowing how to accomplish the above will be most helpful.