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,