Without the "Paste" procedure call with xlPasteValues (only
xlPasteFormats):

1. The formats are copied
2. Excel waits for user action: i select manually destination cell,
strike enter, and then the values are copied too....and the macro ends
immediatly...


I don't understand that....


Regards,

iTarnak


--
itarnak
------------------------------------------------------------------------
itarnak's Profile: http://www.excelforum.com/member.php...o&userid=27865
View this thread: http://www.excelforum.com/showthread...hreadid=473725