Add it to the Tip section
http://www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Ron de Bruin" wrote in message ...
Hi Norman
After I update the page I forget to add this I see now
Will add it to the page this evening
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Norman Jones" wrote in message ...
Hi Celeste,
If you look at other examples, you will see
that Ron provides the optional ability to copy
values and formats.
However, try changing an instruv=ction like:
destrange.Value = sourceRange.Value
to:
sourceRange.Copy
With destrange
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End With
or, perhaps:
sourceRange.Copy Destination:=destrange.
---
Regards.
Norman
"u473" wrote in message
...
Thank you for the tip but I was looking beyond that.
In Excel if you want to copy Values & Formats, as far as I now, you
have to do it in 2 steps.
Can it be done in one sterp in VBA ?
Have a good day, Celeste