Clearing the table content.

Question

My workbook has 12 sheets each having the name of a month. Each sheet contains a table named LotSize?? where ?? = number of the respective month as given below.

Sheet name-Table name: January-LotSize01, February-LotSize02,...., December-LotSize12.

Each of these tables have two columns named SCRIP and LotSize. I want a simple VBA code for following:

1. Clear the content of Lot Size column of each such table from all 12 sheets.
2. Add text A, B, C, D, E in the cells of column SCRIP of each such table in all 12 sheets. I will later replace A, B, C, etc., by actual scrip names.

I am having three different tables on each sheet with LotSize?? (?? = Month number) being one of them.

Answer 1

Hi @Vijay Vardhan,

Thank you for posting your question in the Microsoft Q&A forum.

Regarding your issue, I would like to let you know in this Excel tag, we mainly focus on product features and formulas, so I’m unable to provide detailed assistance for scripting‑related questions. I also do not have the technical environment needed to properly test VBA code.

To receive the most accurate and in‑depth support from specialists who work extensively with Excel scripting, I recommend posting your question in one of the following communities:

• StackOverflow – A very active community for VBA and macro‑related questions. (Note: Microsoft provides this information for your convenience. These sites are not controlled by Microsoft, and we cannot guarantee the quality or safety of any content found there. Please make sure you fully understand the risks before using any suggestions from external links.)

• Microsoft Tech Community – Monitored by Microsoft Engineers and MVPs, offering expert technical guidance.

These platforms are better suited for coding‑focused inquiries and will give your question broader visibility and potentially faster responses from VBA experts.

I sincerely apologize for redirecting you to another community. As I do not have the specialized knowledge required to give accurate advice on this code, I want to ensure you receive the correct guidance from the right experts.

Thank you again for your understanding and patience. If you have any non‑VBA questions or need further assistance with Excel features, I’m here to help.