ExcelBanter - Check cells for validation list

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Check cells for validation list (https://www.excelbanter.com/excel-programming/414628-re-check-cells-validation-list.html)

StumpedAgain

Check cells for validation list

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

All times are GMT +1. The time now is 07:08 AM.