Macro to Disable Cell Calculations on a Sheet
If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula. Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on [...]
Writing a Macro
You may have heard a macro as being referred to also as a sub or subroutine, but any way you phrase it, it is a set of instructions in VBA used to perform an action. Using macros in Excel will greatly enhance your Excel experience and open up many possibilities through flexibility and speed. In [...]
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 [...]
Loading ...