Tag Archives: Word

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 Handle “VBA Not Responding” Errors

VBA is a programming language that is used in conjunction with a host application like Microsoft Word or Microsoft Excel. Its coding standards or syntaxes are very similar to VB 6 or VB script. “VBA not responding" is an irksome and time consuming situation/error that

Word Mail Merge Match Fields

I’ve previously explained about the Address Block and Greeting Line features of Mail Merge in the articles below: Word Mailings Address Block (Mail Merge) Word Mailings Greeting Line (Mail Merge) Basically what they do is, they generate a block of text containing the recipient’s address and

No Thumbnail

Word VBA OverFlow Error When Multiplying/Adding Integers

It might have occurred to you when working with integers in VBA for Word that you get the following error: This error generally occurs when you are doing arithmetic operations on integer values that result in: Values larger than 32767 Values smaller than -32768 This is because integers only

No Thumbnail

Word VBA, Assign Shortcut Key to Macro

This article explains how you can assign a shortcut key or key combination to a macro. – Step 1: Press the “File” button on the top left of the word application, then click on options:   Note: In word 2007, there will be an “Office

Word IF Then Else Rule (Mail Merge) Insert Fields

Previously in the article Word IF Then Else Rule (Mail Merge) I’ve explained how you can use the If Then Rule in Mail Merge. In that article the If Then Else Field would insert a text string based on the result of the comparison. In this article I will

No Thumbnail

Word VBA, Delete Empty Rows From Tables

One of the things a lot of word users encounter while working in word, are empty rows in tables. In this article I will provide a code that will delete all empty rows from all tables in the document. – Delete Empty Rows From Single Table: In

Word Ask Rule (Mail Merge)

In this article I will explain the Ask Rule used in Mail Merge. Note: It is assumed that readers are familiar with Mail Merge before reading this article. – What is it? In Mail Merge we basically have a list of recipients, with specific data for each