How to use VBA to modify tables in Microsoft Word

Changing numerous tables in a Word document one by one would be a tedious project. Instead, use VBA!

Image: PixelMe/Shutterstock

Microsoft Word tables are a powerful feature, and some documents have many. When working with lots of tables, it’s not uncommon for someone to come in at the end and say, “Can you change the tables so they’re all … ?” 

SEE: 83 Excel tips every user should master (TechRepublic)

If you have a lot of tables and someone asks for a lot of formatting changes, you might panic: but don’t. Using VBA’s Tables collection, you can cycle through all the tables in a document and make the same change(s). In this article, I’ll show you two simple VBA procedures that cycle through the Tables collection. The first one converts each table to text. The second, changes the border color to blue.

I’m using…

Keep reading the full content on the TechRepublic site.


Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Comment