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
Category: Excel
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
When Should you Use the Hash Sign (#) in Excel Formulas?
Microsoft Excel Tricks The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference[…]
Read more