Range(Selection, Selection.Offset(0, 1)).Select 'shift-right.


"strung" wrote:


If Excel Macro Codes for Arrow Keys on KeyBoard is:

Selection.Offset(0, 1).Select '*Right*
Selection.Offset(0, -1).Select '*Left*
Selection.Offset(-1, 0).Select '*Up*
Selection.Offset(1, 0).Select '*Down*

Selection.Offset(0, 2).Select '*Right*
is 2 Cells Right respectively.
------------------------------------

What is the code for Shift and Arrow Key ?


I need to Select more than 1 Cell and then Copy that group of Cells.

Thanks in Advance.


--
strung
------------------------------------------------------------------------
strung's Profile: http://www.excelforum.com/member.php...o&userid=24731
View this thread: http://www.excelforum.com/showthread...hreadid=479980