+ Reply to Thread
Results 1 to 2 of 2

Move cursor to next row

  1. 08-04-2006, 04:50 PM #1
    Hank
    Guest

    Move cursor to next row

    Hi, I should make my question simple this time...

    I want to move cursor left from column A to G which is end of column of my
    list and return to next row and start with column A again when I go left
    further.

    Thanks a lot for help

    Hank
    Reply With QuoteRegister To Reply
  2. 08-04-2006, 04:56 PM #2
    Excelenator is offline
    Valued Forum Contributor Excelenator's Avatar
    Join Date
    07-25-2006
    Location
    Wantagh, NY
    Posts
    333
    If you are using Excel 2003 you can select any cell in your "list" and click CTL-L to create a LIST. Then select Tools\Options\Edit and toggle Move on Enter and select Right from the drop down box. Now when you hit enter and you are in column G your "Cursor" or active cell will becom e Cell A in the next row.
    ---------------------------------------------------
    ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
    To insert code into the VBE (Visual Basic Editor)
    1. Copy the code.
    2. Open workbook to paste code into.
    3. Right click any worksheet tab, select View Code
    4. VBE (Visual Basic Editor) opens to that sheets object
    5. You may change to another sheets object or the This Workbook object by double clicking it in the Project window
    6. In the blank space below the word "General" paste the copied code.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1