I know I've found and save the answer to this question but I can't seem to
locate it.

I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some of
the formulas later, but will keep the formats.

Thanks,

Ken