Subscribe
Tutorial search

Macro to Remove Blank Rows - Excel tutorial


Great Microsoft Excel tutorial showing you how to create a macro to remove blank rows. Genius!
Category: Excel > Macros - Difficulty:


More cool Excel tutorials:



Microsoft Office 2007 Tips and Tricks
Microsoft Office 2007 Tips and Tricks
Want to get the most out of Microsoft Office 2007? Maybe a shortcut or two (or 20) that will let you focus on task at hand? Microsoft Office 2007 is so powerful that you need our Tips and Tricks course to make full use of its abilities. You need to be familiar to Microsoft Office 2007 applications already and want to fine tune your work with them.
Difficulty:
Create a Custom Date or Time Format in Excel 2007
Create a Custom Date or Time Format in Excel 2007
A custom date or time format can created in Excel 2007 so save a date or time format that you would like to use again in the future.
Difficulty:
Excel VBA Loop
Excel VBA Loop
The Excel VBA Loop (or For Next loop) is a very useful programming statement which is often used in Excel VBA. First we will look at an easy example of how to loop through a one-dimensional range. You can also loop through a two-dimensional range using a Double Loop. In a similar way you can use three loops (a triple loop) to loop trough two-dimensional ranges on different Excel Worksheets. Besides For Next loops, there are other loops in Excel VBA, such as Do While Loops and For Each Next Loops.
Difficulty:
Overwriting formula to run sensitivites
Overwriting formula to run sensitivites
Shows how to overwrite formula cells when you want to run sensitivities as if they were inputs using AssumeIT macros
Difficulty:
Excel Graphics, Shapes WordArt and Text Boxes
Excel Graphics, Shapes WordArt and Text Boxes
Microsoft Excel has extensive tools for drawing graphic objects.
Difficulty: