Really busy with my son in the hospital for spinal surgery but

sheets("sheet1").select
range("a1").select
or
application.goto sheets("sheet1").range("a1")

range("a1").select
selection.copy
range("b1").select
selection.paste
or
range("a1").copy range("b1")
or
range("b1").value=range("a")

--
Don Guillett
SalesAid Software

"Ron" wrote in message
...
Hi Don,

Could you spare a minute to educate me on this? I'm always appreciative
of
help and improvement.

Ron




"Don Guillett" wrote in news:#dsbshn2FHA.3880
@TK2MSFTNGP12.phx.gbl:

You still need to get rid of all the selections in your code.