Change ActiveCell within a selected range

Hi,

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?

thanks,

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.

Code:

---

Range ("A1:A6").Select
Range("A4").Activate

---