LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Moving cursor

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving the cursor in a macro Amanda Excel Discussion (Misc queries) 1 June 18th 09 02:05 AM
moving cursor PECOSBOB Excel Worksheet Functions 1 January 17th 09 01:27 PM
moving cursor aby New Users to Excel 2 November 2nd 08 10:45 PM
Moving the cursor position Peter Longstaff[_2_] Excel Programming 3 November 25th 05 04:22 PM
moving cursor to text box JT[_2_] Excel Programming 1 February 4th 05 10:13 PM


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"