If you deselect "ignore blank" then you can't enter anything

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Gos-C" wrote in
message ...

That's not valid when A2 is blank.

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile:
http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=537032