Keyboard shortcut to select a column?

[Terry Pinnell]

With a cell selected, I can use Ctrl+ g and enter a new cell, e.g. B3 to
select that cell without using the mouse.

But is there a keystroke method to stay in the current ROW but select a
new COLUMN please?

 

[GS]

With a cell selected, I can use Ctrl+ g and enter a new cell, e.g. B3

to select that cell without using the mouse.

But is there a keystroke method to stay in the current ROW but select
a new COLUMN please?

Did you try using 'Tab' to move left-to-right and 'Shift+Tab' to move
right-to-left?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Terry Pinnell]

Did you try using 'Tab' to move left-to-right and 'Shift+Tab' to move
right-to-left?

Thanks Gary, but I'm looking for something 'absolute' rather than
'relative'. IOW, that won't depend on knowing the current cell.

 

[neeraj.chowdhury]

Try Ctrl+Spacebar for selecting entire column and shift+spacebar for entire row

 

[GS]

Thanks Gary, but I'm looking for something 'absolute' rather than
'relative'. IOW, that won't depend on knowing the current cell.

Not sure what you mean by 'absolute'! The Tab key used as suggested
*absolutely* moves to a new column to the right or left of the current
cell. The only thing 'relative' is that selection remains in the
current row!

If you mean current cell is B3 and you want a keyboard shortcut to go
to H3 then *NO*, there is no shortcut to go to a specific address. In
this case use the GoTo dialog, though simply selecting the cell is
probably easier. Alternatively, you can assign a macro to a keyboard
shortcut and have the macro advance to a specific location.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Terry Pinnell]

Try Ctrl+Spacebar for selecting entire column and shift+spacebar for entire row

How would that achieve what I asked?

 

[Terry Pinnell]

Not sure what you mean by 'absolute'! The Tab key used as suggested
*absolutely* moves to a new column to the right or left of the current
cell. The only thing 'relative' is that selection remains in the
current row!

If you mean current cell is B3 and you want a keyboard shortcut to go
to H3 then *NO*, there is no shortcut to go to a specific address. In
this case use the GoTo dialog, though simply selecting the cell is
probably easier. Alternatively, you can assign a macro to a keyboard
shortcut and have the macro advance to a specific location.

Thanks for the follow-up, Garry. My use of 'relative' and 'absolute' was
probably unclear, sorry.

Yes, your second scenario is the one I was seeking. I've forgotten the
little VBA I once knew so I use Macro Express Pro. I've been using script
lines starting with Ctrl+G for selecting specific addresses like Hn where
n was a known row, but wasn't sure how to handle selections when n was
just 'the current row being processed by the macro'.

Now solved it by getting the row number into a variable at the start and
incrementing it as the macro processes successive line. GoTo then works
fine.

 

[GS]

Thanks for the follow-up, Garry. My use of 'relative' and 'absolute'

was
probably unclear, sorry.

Yes, your second scenario is the one I was seeking. I've forgotten
the
little VBA I once knew so I use Macro Express Pro. I've been using
script
lines starting with Ctrl+G for selecting specific addresses like Hn
where
n was a known row, but wasn't sure how to handle selections when n
was
just 'the current row being processed by the macro'.

Now solved it by getting the row number into a variable at the start
and
incrementing it as the macro processes successive line. GoTo then
works
fine.

That's great! I appreciate the feedback...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion