VBA Code for "SHift+End+Down Arrow"

Posted by bRian Charles on September 22, 1999 6:26 AM

In recording a macro, the key strokes--SHift+End+Arrow Down--
is not recorded as such. Rather as the cells selected.
How do I get the key stroke command into a macor?

Thanks.

Brian Charles

Posted by Ivan Moala on September 22, 1999 8:38 PM

Brian use;
Range(ActiveCell, ActiveCell.End(xlDown)).Select

or send keys command
Application.SendKeys ("{END}+{DOWN}")

Regards

Ivan