Validation is associated with individual cells. Do you want the IF to detect
if ANY cell in the range has validation or if ALL the cells in the range have
validation applied?
--
Gary''s Student - gsnu200796


"Sandy" wrote:

Tried to post this earlier but it didn't seem to arrive??

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