I have a sheet with data where the headers are colored gray and a few other
cells highlighted. I am using VB to make a copy of this sheet into a new
workbook, but all the colors change to an awful bright green and red in the
new sheet. Why is this? I am only doing a straight copy ( or move) of the
new sheet.

I tried doing the copy manually (i.e. Copy, Paste.). Same thing happened.
But the colors are fine when I copy it into another sheet _within_ the
original workbbok.

Is there something wrong with the original sheet to cause this to happen?

Thanks for any insight you all might have, as this is driving me nuts.