Selecting empty cells

[Mike]

Is there a function that will select only the empty cells
in a range, say in a column? As always, thanks a lot.

Mike

 

[Jason Morin]

Select the range, F5, Special, Blanks.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi Mike
what are you trying to do with that information? Depending on this a
formula could be easily achieved. e.g.
=MIN(IF(ISBLANK(A1:A100),ROW(A1:A100))

will return the row number from the first blank cell (entered as array
formula)

 

[Guest]

Thanks, Jason - that was just what I needed

-----Original Message-----
Select the range, F5, Special, Blanks.

HTH
Jason
Atlanta, GA

.