Hi Tomasz:

First create a template worksheet with all you formatting in place. Then
its just a matter of pulling-down:

Edit Move or Copy Sheet... and select template and click make a copy.

If you are comfortable with VBA:

Sub Macro1()
Sheets("template").Copy After:=Sheets("template")
End Sub
--
Gary's Student


"Tomasz Klim" wrote:

Hi

I need a tool, that can analyse existing Excel Sheet, and generate
Visual Basic 6.0 / VBA code, able to generate this sheet from scratch
(add new blank sheet, apply all changes).

I'm interested in column/row sizes, cell colors, borders, cell values,
and formulas. I don't need support for VBA.

Does anybody known such tool?