Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection By Shift & Arrow In VBA
What code enlarge the current selection as by only Shift + Arrow. In other
words, I want the code to only select the currently active cells plus the ones below, like Shift+DownArrow, instead of entering a specific range? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection By Shift & Arrow In VBA
Record the macro to do what you want and you will have the syntax.
-- Regards, OssieMac "FARAZ QURESHI" wrote: What code enlarge the current selection as by only Shift + Arrow. In other words, I want the code to only select the currently active cells plus the ones below, like Shift+DownArrow, instead of entering a specific range? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection By Shift & Arrow In VBA
Activecell.Resize(2,4).Select
will extend the selection from active cell to two rows down and 4 columns to right -- If this post helps click Yes --------------- Jacob Skaria "FARAZ QURESHI" wrote: What code enlarge the current selection as by only Shift + Arrow. In other words, I want the code to only select the currently active cells plus the ones below, like Shift+DownArrow, instead of entering a specific range? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection By Shift & Arrow In VBA
Recording doesn't help my dear. It returns the cell references and not the
actual step. "OssieMac" wrote: Record the macro to do what you want and you will have the syntax. -- Regards, OssieMac "FARAZ QURESHI" wrote: What code enlarge the current selection as by only Shift + Arrow. In other words, I want the code to only select the currently active cells plus the ones below, like Shift+DownArrow, instead of entering a specific range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
Shift and Arrow Key Code | New Users to Excel | |||
CTRL+Shift+Arrow Doesn't Work | Excel Discussion (Misc queries) | |||
Shift+Arrow does not expand selection | Excel Discussion (Misc queries) | |||
Ctrl+Shift+arrow | Excel Worksheet Functions |