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
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