Modify Macro to Include Inserted Rows
I recorded a macro to sort rows:
Sub test2()
'
' test2 Macro
'
'
Rows("2:5").Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub
If I insert rows between 2 and 5 the macro does not change to include
the new rows. How do I change it so it is not a fixed selection?
Chris.....
|