Tag Archives: Rows

Inserting Rows in VBA: 6 Methods to Try

Rows are the horizontal layers of data — whether empty or not — in any table. You can think of a worksheet in MS Excel as a table. Likewise in Word, tables can be inserted and used. Rows are essential part in any table used

How to Delete Rows Using VBA

Why would you want to delete a row? Rows are the horizontal layers of data (that could also be blank) in any table. Worksheets in MS Excel are actually all considered to be tables. In MS Word, tables can be inserted into documents for your

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

Excel VBA, Apply Fill Pattern to Sheet

Jump To: Apply Fill Pattern to Sheet Modify Sheet’s Fill Pattern Color – Apply Fill Pattern to Sheet: The following line of code applies the Reverse Diagonal Stripe fill pattern to sheet 1: Sheet1.Cells.Interior.Pattern = xlDown Before: After: – Modify Sheet’s Fill Pattern Color: The line below

No Thumbnail

Excel VBA, Apply Fill Pattern to Rows

Jump To: Apply Fill Pattern to Row Modify Row’s Fill Pattern Color – Apply Fill Pattern to Row: The following line of code applies the Reverse Diagonal Stripe fill pattern to row 3: Rows(2).Interior.Pattern = xlDown Note: The intellisense may not work while working with the Rows member.

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