Results 1 to 2 of 2

Thread: Change ActiveCell within a selected range

  1. #1

    Change ActiveCell within a selected range


    I was wondering if it is possible to change the ActiveCell within a selected range.

    For example, selecting cell A1 and then pressing shift + down 5 times will give you a selected range A1:A6 where cell A1 is the ActiveCell.

    It is also possible to select cell A6 and press shift+up 5 times to get you back to the same set of selected cells A1:A6, however in this case, cell A6 is the ActiveCell.

    So, given any given range, is it possible to move the ActiveCell within this range?


  2. #2
    Seems to be a common theme that I finally figure things out after posting, but the answer is to use the .Activate method, e.g.

    Range ("A1:A6").Select

Posting Permissions

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