Move range in Excel using VBA

[Cathy]

I cant for the life of me work out this simple task:

I have a named range (a complete row) in Excel and I want to move it down 1 line. Anybody know the trick?

Thanks
Cathy

 

[DennisW]

Cathy,

[VB]
Sub Move_Row()
Dim rnRow As Range

With ActiveSheet
Set rnRow = .Range("Test")
End With

With Application
.ScreenUpdating = False
rnRow.Cut Rows("14:14")
.ScreenUpdating = True
End With

End Sub
[/VB]