Changing active cell within a selection with mouse-click

[derobin]

Hi,

I am wondering how this can be done... I know that one can move forward
and backward with the TAB key, however there has to be a way to do that
by just clicking on the cell to activate. I tried Ctrl+Click,
Alt+Click, Shift+Click, Alt+Ctrl+Click,... nothing seems to work...

Thx for your help.

Robin

 

[Gail]

Click on the cell to activate it? Am not sure exactly what you are trying
to do. If you are in a cell and want to move to another cell, move the
pointer and click.

 

[derobin]

no, Gail I am in a selection: like A1:C9
the heading contains my question...

 

[Gord Dibben]

With range A1:C9 selected and active cell at A1.................

CTRL + Click on B4 to make it active.


Gord Dibben MS Excel MVP

 

[Gail]

Ah now I understand! And I learned something from Gord's response

 

[derobin]

No Gord, that changes the selection type (no bold border around the
selection!) so that you cannot cut the selection for example...!
In vba CTRL+Click looks like this

Range("A1:C9,B5").Select
Range("B5").Activate

whereas I want to achieve

Range("A1:C9").Select
Range("B5").Activate

Any more help is appreciated.

Robin