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?

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?

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?

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?