Run Time Error 1004

indygo

Board Regular
Joined
Dec 2, 2013
Messages
126
Office Version
  1. 365
Platform
  1. Windows
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:

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top