Discussion Locked
Define shift key in Excel macro
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In using the record macro in excel, the pressing of the shift key is not captured. I select the first row. I then use "edit/goto/special/last cell" while hold the shift key. I then copy the selected area. I need the macro to do the same. Here is the macro: Rows("1:1").Select Selection.SpecialCells(xlCellTypeLastCell).Copy
Can any one help?