Sometimes it is useful to know how many times a macro has been run. For example, if you run a macro once a week to perform a particular task, but don't want it run more than once a week, having a counter might be helpful. Copy all of the code below. Paste it into your workbook's Visual Basic editor, either under a Microsoft Excel Object or Module. You can also add other … [Read more...]
Gridlines On/Off
Have you ever set the fill color of an entire sheet (or workbook) to white just because you didn't want to see the gridlines? Well if you have a large file, you could literally reduce the file size in half by not coloring the cells. Simply remove the gridlines (after all that's what you wanted to do in the first place isn't it?). Copy all of the code below. Paste it into … [Read more...]
Avoid Screen Updating
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...]