Tag Archives: Columns

How to Freeze Panes Using Excel and VBA

Introduction Freezing panes is a very handy feature that is indispensable in any Excel workbook that has more than few columns or few rows.  In this article, we will take a look at exactly how to utilize the Freeze Pane feature in both Excel and

No Thumbnail

VBA, Word Table Insert/Remove Rows/Columns

In this article I will explain how you can add and delete rows and columns from tables in a word document using VBA. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the

No Thumbnail

Word VBA Resize Table Columns and Rows

In this article I will explain how you can use VBA for word to resize table columns and rows. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the table index. Tables in