Microsoft KB Archive/38366

{| = Excel: Finding Blank Cells Using FORMULA.FIND in a Macro =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q38366

SUMMARY
To find blank cells in a Microsoft Excel worksheet using a macro, the FORMULA.FIND function can be implemented.

In the following formula, Excel looks for the next cell with a blank value in the active row:

=FORMULA.FIND(&quot;&quot;,2,1,2,1)

MORE INFORMATION
FORMULA.FIND will not find blank cells outside the active area of the worksheet. For example, if cells A1:D50 contain worksheet data, FORMULA.FIND will not find any blank cells outside that range.

For more information about FORMULA.FIND, see page 92 of the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see page 226 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual.
 * }