Clear table content from column/cell to the end of table

Hello Dear Excel Experts,
Can you help me with creating a macro to clear a table starting from Q16 down and to the right. I want to leave the table header and bottom total row. The table will have different number of rolls at different times.

For example table:
Clear contents from Q16 to the bottom of the table and all the columns to the right. Leaving col header and col bottom. In this example all data in the table in yellow Q16 down to Q34 over to AY16 to AY34. The table size will change by more rows being add or deleted each time the file is used.

Any help will be greatly appreciated!!!

Is that what this is about?

Please Login or Register  to view this content.

Hi hungt, it cleared the whole table. I need to keep the data in Columns A through P

Hi bakerman2,
It worked perfectly.

Thank you both bakerman2 and hungt for taking the time to help me with this file. You're the best!!