Detecting if any in a range would be good
sandy

"Gary''s Student" wrote in message
...
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