Need help in swapping values between ranges.

[vikingw2k]

hey guys, I need coding for the function where

1. User select 2 ranges(same length) e.g. A1:E1 and C3:G3
2. Press command button and values in A1:E1 swap with C3:G3
e.g.
BEFORE SWAP - value in A1:E1 = 1,2,3,4,5 and C3:G3 = a,b,c,d,e
AFTER SWAP - value in A1:E1 = a,b,c,d,e and C3:G3 = 1,2,3,4,5

3. Prompts user for 'Comments, then add comments into first cell of both range(A1 and C3)

[Solus Rankin]

Do you mean 'select' ranges as in using the ctrl key to select non-adjacent cells?

[vikingw2k]

Sorry, what I meant was either
1. select 1 cell to swap with another 1 cell OR
2. select few cells(adjacent to each other) to swap with a few cells((adjacent to each other)

[vikingw2k]

Please Login or Register  to view this content.

currently playing around with this coding....

[Solus Rankin]

Try:

Please Login or Register  to view this content.

@Viking Please put your code in code tags.