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