On Thu, 9 Jun 2005 07:03:06 -0500, andrewm
<andrewm.1qcymd_1118318718.9897@excelforum-nospam.com> wrote:

>thanks,
>
>tried counta - started with false when no cells had names, changed to
>true when all cells had an entry, but when I deleted a cells contents
>the counta result stayed with true - any ideas

1. Did you delete using the <delete> key, or did you type in a <space>?

2. Did you set up the data validation for A1:A5 as I suggested?


--ron