If you work in treasury, like I do, and you raise cheques by writing, you may find the code here useful if you have multiple cheques of the same amounts to write. # How it works Usually the name of ...

Upon opening the excel sheet, the user is prompted to enter their userID which will be checked againsts the list under the worksheet 'AuthorizedUsers'. If there is not a match, access is denied. Upon ...

Have you ever found yourself overwhelmed with multiple Excel sheets, each requiring its own header and footer? This is a common challenge, but there’s a way to automate this process. By leveraging the ...

I'm putting together a process for some analysis work that is regularly undertaken. If I'm writing a piece of VBA rather than recording it how do I write it to pick up varying ranges. For example if ...

Don't struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA. If you want to work with VBA, eventually, you’ll struggle with embedded strings. It ...

How to handle VBA’s four most common errors in Microsoft 365 apps Your email has been sent Even experts inadvertently introduce errors into their VBA code. Most of us see some errors more than others, ...