Hi Tom Ogilvy,

I am having the same problem as debartsa but I'm using Excel XP. I hav
been searching for quite some time and try many options but still can'
solve it, this is my code

1 With sheet1.Range("E3").Validation
2 .Delete
3 .Add Type:=xlValidateList, Formula1:="a,b,c,d"
4 .IgnoreBlank = True
5 .InCellDropdown = True
6 End With

I keep getting "Run-time error='1004' Application Defined o
object-defined error" on the line that adds type (line 3). However, i
I move .IgnoreBlank (line 4)or .IncellDropDown (line 5) statement t
above .add Type... (line 3) I get the same error on those statements.

Appreciate if you could help fix this problem.
Thanks

wailoo
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message292105.htm