View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TM[_3_] TM[_3_] is offline
external usenet poster
 
Posts: 2
Default Switching Selections

Hi all

I am trying to build a macro that switches two rows in a worksheet.
i.e A A A A A
D D D D D
switches to
D D D D D
A A A A A
I can do it with absolute cell references but can it be done when the user
selects any two rows in a worksheet, as my way only work in the named cells?

Cheers

TM