Excel 2003 VBA error Method 'add' of object 'valadation' failed
Posted on 2011-09-21
I have an Excel 2003 worksheet that I have inherited.
There are drop downs that depending on what is selected in one gives different options for another cell that has a drop down.
When I select on drop down and then go to the next it i am getting the error
Excel 2003 VBA error Method 'add' of object 'valadation' failed or run-time error 1004 application-defined or object- defined error.
The dropdowns data is referened on another sheet in the work book. any ideas where to start?
the error comes up at .Add in the following code
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlEqual, Formula1:=strPGList
.IgnoreBlank = True
.InCellDropdown = True