VBA ??: ctrl-arrow shortcut
 

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:


---
Message posted from http://www.ExcelForum.com/

VBA ??: ctrl-arrow shortcut
 

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

--
Message posted from http://www.ExcelForum.com

VBA ??: ctrl-arrow shortcut
 

Thanks for the tip and the advice about recording keystrokes.

Cheers,
Erik


---
Message posted from http://www.ExcelForum.com/