View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andreashermle andreashermle is offline
external usenet poster
 
Posts: 123
Default Automatically select entire rows on pressing down and up-arrow key

Dear Experts:

The following code snippets selects the entire row of the currently
selected cell

Rows(ActiveCell.Row).Select

Is it possible to link this entire row selection command to the up and
down arrows of the keyboard?

For example:
The currently selected cell is B5. Pressing the down-arrow-key brings
me to B6. The entire sixth row is to be selected automatically without
manually activating the selection macro.

Is this feasible?

Help is much appreciated.

Thank you very much in advance. Regards, Andreas