Match Formatting

[Chris]

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?

 

[Chris]

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.

 

[Chris]

Sorry! Never mind. Instead of creating a new sheet, I just created a
template and copied that sheet. Easy enough.

Thanks anyway.