Excel: Recreating a Sheet with a Macro?

Question

I'm looking for a simple way to recreate a relatively complex Excel sheet with a macro, inculding cell values, formulas, formatting, and cell size.

Basically, I have an Excel sheet and I need the VB code that would create the sheet. I.e. somewhat like using the macro recorder, but without having to do all the steps in sequence.

Any ideas?

(Copying from a template xls would be much more convenient, of course, but I'm limited to code and can't use additional files in production, for now).

Answer 1

If you don't want to use additional files, put your template as a separate sheet in the same XLS where your macro resides. IMHO, you should avoid having to recreate a complete sheet by code, at least for maintenance reasons.