How do I move the selection down one row in Excel 2007?
It sounds like you just need something like this:
Sub moveselection()
Selection.Offset(1, 0).Select
End Sub
This will move your selection one row down without changing the size of the selection.
(a) That code doesn't move down one row as per question
(b) It will work on only the first row of a selection, did you want it to work on a multiple row selection ?
(c) Rather than call a sub for this you could run it automatically by right clicking your mouse - you can do this by adding right clicking your sheet tab, View Code, and pasting in the code below
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Range("E" & CStr(Selection.Row) & ":" & "GN" & CStr(Selection.Row)).Select
End Sub