Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ??: ctrl-arrow shortcut
Thanks for the tip and the advice about recording keystrokes.
Cheers, Erik --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl+Shift+Arrow key | Excel Discussion (Misc queries) | |||
ctrl+shift+arrow keyboard shortcut issue when typing function | Excel Worksheet Functions | |||
Using Ctrl-arrow to move around excel | New Users to Excel | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
Ctrl+Shift+arrow | Excel Worksheet Functions |