Excel VBA Macro

Select All Cells With Formula In It

Posted on the October 25th, 2008 under Cells and Range by Poer @ Excel VBA/Macro

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 of cells with formula in it (usually a very complex worksheet).

The following vba macro code will do the trick for us.

Sub SelectAllCellsWithFormula()

    'select all cell with formula
    Cells.SpecialCells(xlCellTypeFormulas).Select

    'change cell background color
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent1
        .TintAndShade = 0.399975585192419
        .PatternTintAndShade = 0
    End With

End Sub

FIN

Related Entries

• Finding Cell with Minimum/Maximum Value in Active Worksheet
• Auto Format Excel Cells with Error Value
• Number of Cells/Rows/Columns With Formula
• How To Find the Last Row That Contain Data in Excel?
• Move Cursor To One Cell Below Last Row With Data

External Resources

• Microsoft Excel 2003/2007 Video Tutorials

  Step-by-step video guide to mastering Charts, PivotTable, Data Analysis and Macro programming in Microsoft Excel in 5 hours.

• 101 Secrets of Microsoft Excel

  Discover 101 of Excels little-known secrets that have been hiding right under your nose.

Tagged with: cell with formula, excel special cells, macro code, vba macro