Keyboard shortcut to select a column?

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
T

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?
 
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?
Click to expand...

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
 
GS said:
Did you try using 'Tab' to move left-to-right and 'Shift+Tab' to move
right-to-left?
Click to expand...

Thanks Gary, but I'm looking for something 'absolute' rather than
'relative'. IOW, that won't depend on knowing the current cell.
 
Try Ctrl+Spacebar for selecting entire column and shift+spacebar for entire row
 
GS said:
Thanks Gary, but I'm looking for something 'absolute' rather than
'relative'. IOW, that won't depend on knowing the current cell.
Click to expand...

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
 
GS said:
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.
Click to expand...

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.
 
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.
Click to expand...

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
 
Back
Top