VBA ??: ctrl-arrow shortcut

  • Thread starter Thread starter eyeargan
  • Start date Start date
E

eyeargan

I would like to imitate the ctrl-arrow shortcut I normally use in Excel
to jump over empty cells to reach the next filled cell OR to jump to
the last filled cell in a row or column.

Can anyone help with VBA script for this?

Many thanks --
Erik:confused:
 
This code can be obtained by recording a macro whilst you make those ke
strokes

Here are some code to help you

range("a1")..End(xlDown).Select

or

range("a65536")..End(xlUp).Select

or

range("a1").End(xlToRight).Select


or

range("z1").End(xlToLeft).Select


r = range("a1")..End(xlDown).ro
 
Back
Top