A general library of functions for interacting with different data objects in Excel, and effectively working with array data in memory.

Last time, I wrote a VBA script to check if cells match the same cells in the adjacent sheet. This time, the code has the same purpose, but instead of coloring the cells, it is designed to display the ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...