How AutoSave impacts add-ins and macros
Learn about how AutoSave works in Excel, PowerPoint, and Word, and how it can impact add-ins or macros. Overview of AutoSave When […]
Looping through code
By using conditional statements and looping statements (also called control structures), you can write Visual Basic code that makes decisions and repeats […]
Making faster For...Next loops
Integers use less memory than the Variant data type and are slightly faster to update. However, this difference is only noticeable if […]
Passing arguments efficiently
All arguments are passed to procedures by reference, unless you specify otherwise. This is efficient because all arguments passed by reference take […]
Put Double Quotes in a String in Excel VBA
You will learn: How to put double quotes in a string that already has a quote or double quote in Excel VBA. Take this free course now!
Returning strings from functions
Some functions have two versions: one that returns a Variant data type and one that returns a String data type. The Variant […]
Sheets Vs. Worksheets in Excel VBA
What is the difference between Worksheets and Sheets? Can they be used synonymously? Take this free course now!
The Difference Between Empty, Null and Nothing in VBA
Empty Indicates that no beginning value has been assigned to a Variant variable. An Empty variable is represented as 0 in a […]
Enter and edit data by using Excel Data Form
When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, […]
Understanding Visual Basic syntax
The syntax in a Visual Basic Help topic for a method, function, or statement shows all the elements necessary to use the […]
Understanding Variants
The Variant data type is automatically specified if you don't specify a data type when you declare a constant, variable, or argument. […]
Understanding parameter arrays
A parameter array can be used to pass an array of arguments to a procedure. You don't have to know the number […]