• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drop down list Blank cells [SOLVED]


Excel Ninja
Good day PMMAN

Firstly welcome to the forum please read the green sticky's they will help you in the use of the forum.

As to your question:-

Do not put them there in the first place :)

No but seriously have you checked the range where you are pulling the data validation from to check for blank cells?

Good idea to do as srinidhi has suggested as well but no point in pulling blank cells in the first place


Excel Ninja
Hi ,

There are any number of links on this ; check this :