Do you have a large macro that causes the screen to flash a lot? This can be avoided with two simple lines of code to insert before and after your macro. "Application.ScreenUpdating = False" goes directly before your macro commands and "Application.ScreenUpdating = True" goes directly after your commands, and before the "End Sub". Copy all of the code below. Paste it into … [Read more...]
Install and Use Macros
So you've found the perfect macro code to speed up that tedious and repetitive task - now what? In this section, we'll walk you through the several ways to install and use your macro code. We'll show you how to get comfortable with macros in excel before moving on to move on to perform more complex tasks. Once you know how to use macros in Excel you will have the ability to … [Read more...]