Changing active cell within a selection with mouse-click

  • Thread starter Thread starter derobin
  • Start date Start date
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
 
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.
 
With range A1:C9 selected and active cell at A1.................

CTRL + Click on B4 to make it active.


Gord Dibben MS Excel MVP
 
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
 
Back
Top