Thursday, March 26, 2009

Macros in Excel : Find Blank Cells Macro

In case you need to select blank cells within range , use following macro code. Since this works on pre selected range of data, so make sure that you have selected the required data range before running your macro.

Let us take an example. if you want to find blank cells with in "A2:D10", make sure that you have select this range before running the macro.

Sub Find_Blank_Cells()

Selection.SpecialCells(xlCellTypeBlanks).Select

End Sub

2 comments:

  1. I am definitely enjoying your website. You definitely have some great insight and great stories.
    excel macro training courses london

    ReplyDelete