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?