VBA Code for ‘Last Week’s Saturday’ – & other dates!

These codes come in handy for me all of the time - Whenever I need to automatically save a report with the Week Ending Date, or if I need to calculate something from a SQL query that needs a specific date, I chuck one of these codes. I thought it might come in handy for … Continue reading VBA Code for ‘Last Week’s Saturday’ – & other dates!

Quickly Comment/Uncomment code in VBA

Unfortunately, there's no shortcut for commenting/uncommenting blocks of code in VBA - but there are a couple of handy buttons you can add to your toolbar to save you from going through and adding/removing apostrophes from every. single. line! Just follow these steps to turn on the toolbar buttons: In your Excel workbook, if you … Continue reading Quickly Comment/Uncomment code in VBA