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 [...]
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 [...]
