Copy and Paste

  • Thread starter Thread starter FLKulchar
  • Start date Start date
F

FLKulchar

I would like to EXCHANGE the contents of one cell with
another...

e.g. cell A1 contains.... 25
cell A2 contains ... 65

Can I copy A1 into A2 using some form of paste special to
EXCHANGE the 2 values?

Thanks,

Larry
 
Hi Larry
you would need a macro to achieve this change. There is no such 'paste
special' option for this
 
You would need a macro something like
x=range("a1")
y=range("a2")
range("a2")=x
range("a1")=y
 
If this is a one time thing and the cells in question
contain data and no formula's, you can use the copy &
paste or the cut & past, for example: copy A1 to A3, copy
A2 to A1, Copy A3 to A2. Delete contents of A3.

Charlie O'Neill
 
Back
Top