Thread
:
Using Validation.Type on a Range
View Single Post
#
1
Posted to microsoft.public.excel.programming
blisspikle[_2_]
external usenet poster
Posts: 3
Using Validation.Type on a Range
I can do the following...
If Selection.Validation.Type = xlValidateList Then
Else
End If
Why can't I use...
If Worksheets(1).Cells(7,1).Validation.Type = xlValidateList Then
Else
End If
I am using Office 2003
Thanks,
Reply With Quote
blisspikle[_2_]
View Public Profile
Find all posts by blisspikle[_2_]
Using Validation.Type on a Range