Help with Macro - copy worksheet

[ann21236]

I found a Macro that creates a new sheet and copies information form another worksheet. I need it to copy the formatting from the old sheet to the new sheet. It copies the information just fine, but it needs to copy the format too. Any help that could be provided would be greatly appreciated.

[JieJenn]

I think this might work

Please Login or Register  to view this content.

[ann21236]

I tried it, but it didn't work. It still copies without formatting. Thanks anyways.