Selection By Shift & Arrow In VBA

[FARAZ QURESHI]

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?

 

[OssieMac]

Record the macro to do what you want and you will have the syntax.

 

[Jacob Skaria]

Activecell.Resize(2,4).Select

will extend the selection from active cell to two rows down and 4 columns to
right

 

[FARAZ QURESHI]

Recording doesn't help my dear. It returns the cell references and not the
actual step.