working with selected cells
 

Hi,
I wish to select two sequential rows and do some manipulation, like
moving cells from one row to the other. how do i accomplish this using
excel macros?
for example, i want to move the 2nd cell in the 2nd row of my selection
to the 7th column in the first row. then i want to move cells 2-7 in
the first row to cells 1-6.
thanks
Vishnu