Moving cursor to next open cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wolf - 16 Dec 2004 19:21 GMT

What command do I need to type to move the cursor one cell down? I have
created a macro that copies an entire line of data to a spreadsheet by going
to a specific column, using the end and down commands, to find the first
empty cell. My problem is that after I have recorded the macro, the cursor
never moves down that one cell and keeps copying the data on that same line.
I have tried multiple times with it recording what I want, but VBA will not
move down to the next empty cell on subsequent runs. Any help would be
appreciated.

Reply to this Message

Paul B - 16 Dec 2004 19:32 GMT

Wolf, try this, with data in column A

Range("A65536").End(xlUp).Offset(1, 0).Select

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> What command do I need to type to move the cursor one cell down? I have
> created a macro that copies an entire line of data to a spreadsheet by
[quoted text clipped - 8 lines]
> move down to the next empty cell on subsequent runs. Any help would be
> appreciated.

Reply to this Message

Wolf - 16 Dec 2004 19:47 GMT

Paul B.

Thank you so much. It worked just fine. I had built a spreadsheet in
Quattro Pro and had to switch it to Excel and was going crazy. I really
appreciate your help. This forum was just the ticket I needed.

Thanks again.

> Wolf, try this, with data in column A
>
[quoted text clipped - 11 lines]
> > move down to the next empty cell on subsequent runs. Any help would be
> > appreciated.

Reply to this Message

Paul B - 16 Dec 2004 20:59 GMT

Wolf, your welcome

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Paul B.
>
[quoted text clipped - 21 lines]
>> > move down to the next empty cell on subsequent runs. Any help would be
>> > appreciated.

Reply to this Message