I would try using pastespecial. I suspect that the Pastespecial options
are going to show up differently when the workbook is opened verses
closed. Ossie is probably right that when the workbook is opened it is
point to the old workbook which has the formating of the cells
accessable. When you cclose the workbook the either the formating is
being eliminated or the options that paste is using is different.

Microsoft programs have algorithms built in the make decision
automatically. These decision making algorithms don't always make the
decisions you want them to make. The problem may be that the paste
option is changing when the workbook is closed. The default condition
for a paste is to paste everything when using just excel. When you
close the workbook the source workbook credentials are lost. So the
algorithm doesn't know if the data came from a workbook or maybe word
document. So the paste operation picks the best formating style to
perform that paste operation.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=178994

Microsoft Office Help