Create table for all worksheets

[stephme55]

Hello. If I have data in column A and B with headers in ten worksheets, how can I create a table for every worksheet without having to go in and manually do it?

[davesexcel]

This will loop through the sheets and create the tables, the 2nd code will loop through the sheets and remove the tables.

Please Login or Register  to view this content.