Can you tell me what you exactly want to do?
When reading your code it is not clear to me

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"smandula" wrote in message ups.com...
On Apr 27, 4:59 pm, "Ron de Bruin" wrote:
Instead of the Value property you can use pasteSpecial.
paste the Formats first and then the values

See the VBA help for pastespecial

I need more help in executing your suggestion.