| 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 | |||
Linear Mode
