INFO function in Excel

The INFO function in Excel returns information about the current operating environment.  In total, there are seven pieces of information available: File path of the current folder Number of worksheets in open workbooks Cell reference to the top-left visible cell of the window Operating system version Excel’s calculation mode Excel version Type of operating system Read More

VBA code to copy, move, delete and manage files

Automating processes with VBA can involve copying, moving, deleting and managing lots of files.  Thankfully, VBA has many built-in functions to undertake these tasks for us.  These files do not necessarily need to be Excel workbooks; they can be any file type. The filename for this post is 0041 VBA copy, move, delete and manage Read More

Advanced dynamic array formula techniques

In the final part of this dynamic array series, we’ll look at a few advanced formula techniques.  We won’t be covering the individual functions in detail but considering how we can combine them to solve some tricky problems.  Many of these techniques have been covered briefly as examples in previous posts, but now we’ll dig Read More