I couldn't duplicate this in xl2003.

What version of excel are you using and what's the custom number format?

tmbo wrote:

Hi, thanks in advance for anyone who can help.

When I run the above command embedded in a macro it does the copy sheet
command sucessfully but loses the number format of the original.

When I use the Excel edit move or copy sheet to do the same thing it
preserves the number format (which is a custom format).

I really need to preserve the original number formats. Anyone have any
ideas?

--
tmbo
------------------------------------------------------------------------
tmbo's Profile: http://www.excelforum.com/member.php...o&userid=37214
View this thread: http://www.excelforum.com/showthread...hreadid=569306

--

Dave Peterson