Formatting multiple copied sheets in macro

I have a file with a macro that creates a new sheet named New Record. We use this new sheet to enter data and then rename the sheet 2010Q1, 2010Q2 etc to represent the year and current quarter. I also have a macro that is capable of coping anyone of the sheets and/or multiple sheets (depending on which tab I want to copy at that time) and exports them to new workbook. The macro reformats the first sheet but not multiple sheets. How can I get it to format the additional sheets selected after the first sheet? Below is what I have so far:

Thanks,

Please edit your original post above and put code tags on your code, as shown in my signature. I think I can tweak that macro for you.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

As long as you delete that code from post #1 (which is still incorrectly posted), we're good.

Try this:

Please Login or Register  to view this content.