Sorting an array alphabetically with VBA

VBA Code Snippets

At some point in your VBA life it will be necessary to display or re-order an array/list alphabetically (or reverse alphabetically).  Unfortunately, VBA doesn’t have a function for sorting arrays automatically, but with a little bit of coding we can create a reusable function which would achieve something similar. Setting up the example This first VBA … Read more

Excel’s hidden camera tool

Hidden Camera Tool

The camera tool is probably one of the most underutilized tools in Excel. The reason it is underutilized is because it is hidden. This simple tool will take a picture of a range of cells and place the picture of those cells on another part of the workbook.  You can move, re-size and add picture formatting options the picture. … Read more