Empty Cell

[tchen]

Is there a way to search for a blank cell within a huge range? Please help!!

[Gary's Student]

I tried this and it works. I filled an entire worksheet with "1" and then
cleared a single cell.

I was able to locate the blank cell with Edit > Find
I put nothing in the find field and sure enough it found it.

Good Luck
--
Gary's Student


"tchen" wrote:

>
> Is there a way to search for a blank cell within a huge range? Please
> help!!
>
>
> --
> tchen
> ------------------------------------------------------------------------
> tchen's Profile: http://www.excelforum.com/member.php...o&userid=26060
> View this thread: http://www.excelforum.com/showthread...hreadid=400970
>
>