Tag Archives: vba macro

Number of Cells/Rows/Columns With Formula

Posted on January 29, 2009 by Admin

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 formula – Number of Columns with … Continue reading →

Posted in Cells and Range, Workbook and Worksheet | Tagged cells, columns, excel cells, excel formula, excel macro count rows, excel macro count the no of rows with text, excel vba count rows, rows, vba count rows, vba macro, worksheet cells | 52 Comments

Select All Cells With Formula In It

Posted on October 25, 2008 by Admin

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 is time consuming, especially on Excel Worksheet with large … Continue reading →

Posted in Cells and Range | Tagged cell with formula, excel special cells, macro code, vba macro | 6 Comments

Move Cursor To One Cell Below Last Row With Data

Posted on October 15, 2008 by Admin

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. ‘first, select cell in the first row of that column, like A1, K1, … Continue reading →

Posted in Excel VBA Function | Tagged ActiveCell, excel macro move cursor, excel macro select cell below, excel vba, excel vba find last row, excel vba find last row with data, excel vba move cursor, last row with data, move cursor, Offset, vba macro, vba move cursor | 19 Comments

Finding Cell with Minimum/Maximum Value in Active Worksheet

Posted on October 4, 2008 by Admin

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 to make it stand out before other cells. The logic … Continue reading →

Posted in Excel VBA Function, Workbook and Worksheet | Tagged cell function, excel formula, excel macro, excel tutorial, excel vba formula, Excel VBA Function, excel vba max, excel vba max value, excel vba max value in column, excel vba maximum value, excel vba minimum, learn excel, macro cell, maximum cell value, minimum cell value, vba cell, vba excel, vba macro, vba minimum | 10 Comments

How To Hide an Excel Worksheet

Posted on September 24, 2008 by Admin

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 the method explained above is right, but unfortunately, others … Continue reading →

Posted in Workbook and Worksheet | Tagged Excel, excel macro, excel vba, excel vba hide all worksheets, excel vba hide column, excel vba hide sheet, excel vba hide worksheet, excel vba hide worksheets, excel workbook, excel worksheet, Hide sheet vba, hide worksheet, hide worksheet vba, Microsoft, microsoft excel, VBA, vba excel hide sheet, vba hide sheet, vba hide worksheet, vba macro, VeryHidden, visual basic editor, Workbook, Worksheet, xlSheetVeryHidden | 7 Comments

Changing Microsoft Excel Status Bar

Posted on September 10, 2008 by Admin

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, to do it, put this following code in … Continue reading →

Posted in Excel VBA Function | Tagged excel status bar, status bar, vba function, vba macro | 6 Comments