This tutorial will show you how to format cells using custom number formats that include icons and emojis. Conditional formatting as you may know provides a limited selection of icon sets, but if you are after more variety or indeed a bit of fun with your Excel spreadsheet then this is for you. Download the… Read More »Including Icons and Emojis in Excel’s Custom Number Formats
Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives. To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library. In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and click OK. You… Read More »Excel VBA File Management Using The FileSytemObject
What is an Array? An array, like a variable is a somewhere to store data. An array can however hold more than one value, for example an entire database of information with tens of thousands of records. Using arrays in your procedures makes your code potentially quicker than alternative methods for say performing calculations on… Read More »Excel VBA – Storing Data in Arrays & Dynamic Arrays