Looping through every worksheet or every workbook is a very common action. One which you may be doing on a regular basis. The code below should set you on the right path. Loop through every worksheet Sub LoopThroughWorksheets() ‘Create a variable to hold the worksheet and also the output message Dim Ws As Worksheet Dim … Read more
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
Hey! It’s Spreadsheet Day! Woop Woop! I’m not even kidding, this is a real thing. Just google it and you will see. On 17 October 1979 the first spreadsheet program, Visicalc, became available for on the Apple II computer. This is what it looked like back then (image from Wikipedia) Whilst a lot has changed … Read more
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
In the last few days I’ve been asked a few questions by work colleagues regarding the visibility of sheets: This cell references a sheet, why I can’t find the sheet? Is it possible to unhide multiple sheets at the same time? So, let’s take a look the process of hiding, unhiding and making sheets invisible. … Read more