Run Time Error 1004

indygo

Board Regular
Joined
Dec 2, 2013
Messages
117
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
 
Last edited:

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

indygo

Board Regular
Joined
Dec 2, 2013
Messages
117
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-known Member
Joined
Jul 14, 2010
Messages
1,343
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,923
Messages
5,525,653
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top