Run Time Error 1004

[indygo]

So I have two excel versions one at home and one at work. Both are excel 2016 but the one at work is blocked for updates.

The bug I'm getting is on the most up-to-date version at home. Excel at work doesn't seem to have this bug.

And here's the code:

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula:=TeamList


Bug is related to dropdown menu.

Any ideas if I'm missing something in my excel settings here?

Regards

 

[bobsan42]

I guess you are having Validation in mind:

[B].Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula[COLOR=#ff0000]1[/COLOR]:=TeamList[/B]

https://docs.microsoft.com/en-us/office/vba/api/excel.validation.add

 

[indygo]

I mean I have the same code on two machines and one gives me runtime error and the other works perfectly fine.

It's a validation box where it looks up team name and then looks up values in another sheet.

 

[bobsan42]

Well. I don't know, I can't compare your files and code. Certainly the named argument for this method is not Formula, but Formula1 and Formula2.
The difference is just 1 digit. This is the reason you get RTE 1004.

 

[indygo]

thanks