+ Reply to Thread
Results 1 to 7 of 7

Return Cursor To Start Of Matrix

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Hopkinsville, KY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Return Cursor To Start Of Matrix

    I have a spreadsheet that includes a header and data matrix. The header includes 4 rows, each row having 2 merged cells (B4:C4, B5:C5, B6:C6 and B7:C7). My data matrix includes cells B11:E15. All others cells in the spreadsheet are locked. After completing the header it will remain the same for all instances of completing the data matrix. However, when I complete the data matrix by completing cell E15, I want the cursor to automatically return to cell B11 rather than returning to the merged header cell B4:C4. Can anyone help me with the worksheet VBA code to complete this task?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Return Cursor To Start Of Matrix

    Hello QualityMan,

    Welcome to this Forum.

    You could use:
    Please Login or Register  to view this content.
    Hope that helps.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    Hopkinsville, KY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Return Cursor To Start Of Matrix

    Winon, this is a start but what it does is put the cursor in B11 and then doesn't let me move it from there.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Return Cursor To Start Of Matrix

    Hello QualityMan,

    Okay then, let us try this one.

    Please Login or Register  to view this content.
    Last edited by Winon; 06-27-2013 at 05:44 PM. Reason: Changed Code

  5. #5
    Registered User
    Join Date
    06-27-2013
    Location
    Hopkinsville, KY
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Return Cursor To Start Of Matrix

    Ok, I tried this one and it will let me move the cursor into the 4 header cells and cell B11 but nowhere else.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Return Cursor To Start Of Matrix

    Maybe

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Return Cursor To Start Of Matrix

    Hello QualityMan,

    It is because, as you state in your first Post.

    My data matrix includes cells B11:E15. All others cells in the spreadsheet are locked.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1