Thread: Swap 2 lines
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Petter Petter is offline
external usenet poster
  
Posts: 9
Default Swap 2 lines
Sub Short()
Rows("19:19").Cut
Rows("21:21").Insert Shift:=xlDown
End Sub

"kirkm" wrote:


What would be the best way, in code, to swap entire lines 19 and 20
in sheet1 ?

Thanks - Kirk

Reply With QuoteReply With Quote