+ Reply to Thread
Results 1 to 2 of 2

Check selected cells are right of active cell

  1. #1
    Registered User
    Join Date
    06-12-2007
    Posts
    1

    Check selected cells are right of active cell

    Basically, I need to check that when someone selects 3 or 4 cells and clicks a command button the selected cells are all to the right of the original active cell. If they're not at message box would be displayed. If anyone knows how to code that I would appreciate it.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Papata123,

    Once the cells are selected they become the ActiveCell. Without some constraints on what defines the location of your original active cell, like a certain column, row, or group of cells, you can not realistically know the relationship between the previous cell and the current cell(s).

    Sincerely,
    Leith Ross

+ 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