Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)
Excel VBA Tutorials It’s best practice to declare your Excel VBA variables before you use them. Declaring variables means that[…]
Read more
Author: Noel
Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder
Excel VBA Tutorials Use the DIR function in Excel VBA to check if a file or a folder exist. You[…]
Read more
Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
Excel VBA Tutorials Referencing ranges is a common task in Excel VBA. It’s important to be aware of the different[…]
Read more
Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook
Excel VBA Tutorials Interested to learn how to apply Excel VBA Arrays to real world examples? Learn how to declare[…]
Read more
Easily Calculate Ratios in Excel
Microsoft Excel Tricks Learn to easily calculate the ratio of two numbers in Excel with Excel formulas. A ratio tells[…]
Read more