Gary's Student already answered this question.

http://www.microsoft.com/office/comm...7-e140c6770be7
--
-SA


"Sandy" wrote:

How do I check for validation list in a range

Roughly:-

If Range("C30:K30,C36:K36") has validation then

*****Code******
Else

*****Code******
End If

Thanks
Sandy