And exactly where in your original post did you state that you had 5000
cells, pray tell.


"Gary" wrote:

Nice joke JMB, I have 5000 cells to swap.

any idea?

"JMB" wrote in message
...
Select cell A1. Type in 100. Hit Enter.
Same process for cell A2.


"Gary" wrote:

I want to swap values of two cells. can anyone help me on that? Eg. Cell
A1
contains the value 20 & cell A2 contains the value 100. I want 100 on A1
&
20 on A2.

Thanks
Gary