View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

Wolf, try this, with data in column A


Range("A65536").End(xlUp).Offset(1, 0).Select
--
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


"Wolf" wrote in message
...
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.