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
Tag: training
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
Your Own Tab in Excel because… Why not?
Microsoft Excel Tricks Customize Excel, Word and PowerPoint by creating your own tab in the Ribbon. This way you can[…]
Read more