The Instr function in VBA checks to see if a string is contained within another string. This can be useful when trying to extract information from strings of data contained in Excel cells, for example. Instr Syntax The Instr function is made up of 4
A variable is a named storage location in which you can store information while your macro/program is running. Each variable has a unique name where the name can identify what type of variable it is by using standard naming conventions. A variable can contain different
What is a Hyperlink? A hyperlink is a word, phrase, or image that you can click on to jump to a new document or a new section within the current document. Text hyperlinks are often blue and underlined, but not necessarily. When you move the
The Table object in Excel and Word is underutilized by most users and developers of Excel and Word, in my not-so-humble opinion. For example, an Excel Table object with formulas calculates faster and takes less storage space than does the comparable normal range. As useful
This article shows how to use VBA in MS Word to delete empty rows from a table or rows that have at least one cell that is empty. Say you have multiple tables in a Word document and you want to print the document with
In this article, we will see how to access the various word objects using VBA in Excel and insert data from Excel to Word. This has many practical applications such as when you have to fill out a form multiple times with data from Excel or
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.