View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default Shift and Arrow Key Code

Try

ActiveCell.Resize(num_rows,num_columns).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"strung"
wrote in message
...

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