Be advised that when you use this for more than ONE cell you make sure they
are the same size ranges.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ogopogo5" wrote in message
...
Thank you Jim. I will use your code Range("S1").value =
range("L63").value as it works.

Ogopogo5

*** Sent via Developersdex http://www.developersdex.com ***