Copy Formatting to new worksheet?

[Al Franz]

I would suspect the answer to this is no but just by chance is there anyway
to copy all the formatting of a worksheet to a new worksheet without any of
the data. Copy just colors, column widths, etc. Would come in handy for
importing CSV data and then quickly formatting to a predetermined format.

[Ken Wright]

Edit / Paste special / formats only?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Al Franz" <albert@nospam.netmation.com> wrote in message
news:e9Jd%23zgBFHA.2568@TK2MSFTNGP11.phx.gbl...
> I would suspect the answer to this is no but just by chance is there
anyway
> to copy all the formatting of a worksheet to a new worksheet without any
of
> the data. Copy just colors, column widths, etc. Would come in handy for
> importing CSV data and then quickly formatting to a predetermined format.
>
>