Macro to swap cells

  • Thread starter Thread starter Brian Cryer
  • Start date Start date
B

Brian Cryer

I would like a macro that would move the currently highlighted block up one
row, moving the cells that were above to below. Its something I would find
very useful.

TIA.
 
The macro recorder is your friend. Then you can clean it up.
Sub Macro6()
'
' Macro6 Macro
' Macro recorded 7/14/2007 by Donald B. Guillett
'

'
Rows("13:13").Select
Selection.Cut
Rows("12:12").Select
Selection.Insert Shift:=xlDown
End Sub

Sub cleanupupcut()'does the same
Rows(ActiveCell.Row).Cut
Rows(ActiveCell.Row - 1).Insert
End Sub
 
Thank you Don. I knew that must be an easy way of doing it. This is great,
and I've build on it to do exactly what I'm after.
 
Back
Top