Excel Video 425 has one line of code that makes your macros much easier to run as the size of your data changes. Watch for how we create the FindEnd variable that finds the bottom row of your data, and then watch for how we use FindEnd to make our loop work. If the size of the data you want to run your macro against changes, the 4 minutes it will take you to watch Excel Video 425 will be repaid time and time again. I hope you find the code helpful. Thanks for watching.
Excel Video 425 Looping to the End of the Data
by Nate Moore | Sep 1, 2014 | Macros and VBA