Not necessarily.

Check the InCellDropdown property of the Validation object

Range("A1").Validation.InCellDropDown

will be True or False.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Bob Phillips" wrote in message
...
One has Data Validation applied to it, the other doesn't See
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jac Tremblay" wrote in message
...
Hi everyone,
I want to know how to distinguish between a cell that displays a drop
down
list in a cell and another that does not.

Thank you.