Why Do You Need to Insert Anyway? There are instances where we might forget to add data while creating a Word document or Excel spreadsheet. When we realize our mistake later, we can go in and add it using insert rows/columns, insert pages/shapes/images, etc., and
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
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
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
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
In this article I will explain how you can apply formatting to certain characters in a word equation. Below are some of the things you might want to do: Change numbers to italic Change number to bold Change the font color of certain characters Replace certain
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
In this article I will explain how you can use VBA for Word to split a word document every X pages. Each section will be saved in a separate document. – Splitting Every X Pages: In this example the word document will be split every 3 pages.
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
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