by Dan Strong | May 5, 2020 | Efficiency, Speed Lessons
Sometimes in Excel, we need to automate simple tasks, like to create sheets automatically for each item in a range. If you just had a few worksheet tabs that needed to be created, it wouldn’t be a big deal, but what if you had to create 100 different worksheet...
by Dan Strong | May 31, 2015 | Excel VBA Tips, Speed Lessons
One of the most important things you’ll learn in Excel VBA is grabbing the last row in your code. Here’s how to do it. Let’s say we need the bottom used cell in column A (column 1), we can copy/paste this code for the row number: [cc...