On Aug 17, 10:05 am, Chris wrote:
My VBA code creates multiple sheets and fills them with data. Each
time a new sheet is created it has default formatting. I have a sheet
that's formatted exactly as I want it, and I'd like for these newly
created sheets to take on that formatting.

Is there any way I can code it so that the formatting of the new
sheets is the same as the formatting of that existing sheet?

When I say formatting, the things in particular that I'm looking are
data type (number, date, percentage, etc.) and column width. I'd
really like for new sheets to retain those properties.