data swap

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

is it possible to swap cells without having to cut and paste? if i have data
in b3:b5 and c3:c5, and i want the data in each column to switch, is there a
function that allows me to do that?
 
Not without resorting to a macro

Right click the sheet tab, view code and paste this in and run it

Sub swap()
Range("B3:B5").Copy
Range("A65534").PasteSpecial
Range("C3:C5").Copy
Range("B3").PasteSpecial
Range("A65534:A65536").Copy
Range("C3").PasteSpecial
End Sub

Mike
 
Back
Top