Microsoft Excel is jam packed with cool useful features that tend to go unused by most users, simply because they don't know how to use them, or even that they exist. One of these features is Excel's Goal Seek tool. First, some background on what it does. Goal Seek is essentially the answer to every middle school aged kid's math test word problem. It is best used when you … [Read more...]
Create and Name a New Worksheet
Say you have a spreadsheet that keeps track of weekly sales information, which you want displayed in a new sheet for each month. You don't want to copy an "original" worksheet each week, so a macro can help to automate this process. The macro code below will copy the worksheet named "Original", and place it after the last worksheet in your file. It will then prompt you to … [Read more...]
Run Macro At a Specified Time
Using the Application.OnTime Method will allow you to schedule a macro to be run at a specified time. The specified time can be either after certain amount of time has passed, or at a certain time of day. This is especially useful if you would like a daily or weekly report to be printed, without having to be around to print it. If the report is long, it might take a while to … [Read more...]
Run Macro Automatically on Open
Insert your macro code into a module, start with Sub Auto_Open(). Enter whatever commands you wish to have executed on opening the file and end with End Sub. This will make Excel run macro on open and is the quickest way to run a macro automatically on opening an excel workbook. Excel Run Macro on Open To automatically run a macro when you open excel, follow these simple … [Read more...]