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.

"derobin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

Gail schrieb:

> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >

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

CTRL + Click on B4 to make it active.


Gord Dibben MS Excel MVP

On 17 Aug 2006 08:22:37 -0700, "derobin" <(E-Mail Removed)> wrote:

>no, Gail I am in a selection: like A1:C9
>the heading contains my question...
>
>Gail schrieb:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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
>> >

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


"derobin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> no, Gail I am in a selection: like A1:C9
> the heading contains my question...
>
> Gail schrieb:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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
>> >
>

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

Gord Dibben schrieb:

> With range A1:C9 selected and active cell at A1.................
>
> CTRL + Click on B4 to make it active.
>
>
> Gord Dibben MS Excel MVP
>
> On 17 Aug 2006 08:22:37 -0700, "derobin" <(E-Mail Removed)> wrote:
>
> >no, Gail I am in a selection: like A1:C9
> >the heading contains my question...
> >
> >Gail schrieb:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > 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
> >> >