Changing active cell within a selection with mouse-click

D

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
 
G

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.
 
G

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
 
D

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
 
Top