Count Pivot Tables and add a table

  • Hello forum,

    I have a weekly Excel workbook with a separate Sheet for each workday. Each Sheet has data that I want to convert into a table with VBA. I recorded the code below but it will not function correctly after the first sheet is saved. The error message comes back with "a table can't overlap another table". Is there a way to count the number of current tables in the workbook and have VBA create a new table with the next Table#?



    I appreciate your feedback,

    Thank you

  • It's poor workbook design to have data separated on different sheets.


    Your code will only work on the ActiveSheet and on the specified range, if a Table already exists there you will get that error message.


    You need to loop through the sheets check if a Table exists and create the Table if not.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!