How do I move the selection down one row in Excel 2007?

Question

Is there a way to move a selected range to the next row?

Let's say I have "E9:H9" selected and want the selection to move to "E10:H10". Is there a shortcut for it? The selection should not be extended but moved one row down.

Answer 1

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.

Answer 2

(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

Answer 3

Ok,

The cursor has to be in the row and the ranges "E" and "GN" need adjustement for different columns but it saves me some time:

Sub SelectRange()

  Dim RowNumber As Integer

  RowNumber = Selection.Row
  Range("E" & CStr(RowNumber) & ":" & "GN" & CStr(RowNumber)).Select

End Sub