Using the Status Bar to Display Messages
Excel provides an easy way to show the end user messages about the status of a macro that is running. This can be a useful way of updating users, especially during long running macros, as to the status of the routine. Some users need updates from the system to let them know that the program [...]
Count Rows with Data in a Macro
For this Excel tip, let’s look at an easy way to count the number of rows containing data in a spreadsheet. One way would be to do use a for loop and a counting variable, but that contains unnecessary steps to get the job done.
A simple way to count the number of rows in a spreadsheet is [...]
Using a For Loop in a Macro
If you’re new to macros, you might want to check out a previous post I made Familiarizing with the Visual Basic Editor and Use the Record Macro Feature. Basically, the purpose of a macro in Excel is to provide you with a way of quickly and easily modifying the values in your spreadsheet. Actually, there are [...]
Use the Record Macro Feature in Excel
One of the easiest ways to begin learning how to use the Macro ability of excel is to use the “Record Macro” button. To begin recording a macro, goto Tools->Macro->Record New Macro. After you hit that button, any actions you perform will be recorded. When you are finished performing the actions hit the “Stop” button [...]
Adding an Excel Macro Section to Excel Hints
I use excel macros everyday with my current job duties. A section I will soon be adding to ExcelHints.com is examples of macros that I use all the time. Macros can be used for several reasons, the most common is when there is a task that you need done on regular basis. Automating the process [...]
Loading ...