It's always useful to have a calendar in Excel. Having one lets you save it on a shared network drive, so everyone involved in a particular project knows what's going on and important dates coming up. Creating a calendar in Excel can be a tedious task if done manually. Thankfully, using the Visual Basic Editor, you can easily create a calendar in Excel. By creating a simple … [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...]