What file exttension are you saving XLS or CSV? CSV will not save the
formatting. I think your problem is the file extension you are using.

"Genesis" wrote:

I have a macro that saves the current worksheet only (fileformat=xlNormal),
and automatically generates a new filename, but formatting is lost, so
reprinting the sheet looks completely different from the original.