Number of Cells/Rows/Columns With Formula

A few weeks ago I received this question from someone called LS: Hi I want to write a macro that counts the following - Number of cells with formula - Number of Rows with ... Read more..

Select All Cells With Formula In It

Let say we want to distinguish between ordinary cells and cells with formula in it, so we give a special background color to the cells with formula.For doing it manually ... Read more..

Move Cursor To One Cell Below Last Row With Data

Ever want to paste some data into new empty cell after the last cell with data in certain column? Then take a look at this simple macro.... Read more..

Finding Cell with Minimum/Maximum Value in Active Worksheet

Let say we want to find position of cell containing the minimum/maximum value in current/active Excel worksheet, and then after we found the cell, we will change the cell format ... Read more..

How To Hide an Excel Worksheet

Some time we want to hide a certain Excel Worksheet from view, and it's a common practice to use select the Worksheet, go to menu Format > Sheet > Hide.Using ... Read more..

Changing Microsoft Excel Status Bar

Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us.The end result will look like this:Ok, ... Read more..