gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
Here is what I am using but I get a Run Time Error 1004
Method 'Range' of object'_Global' failed
Sheets("Cost Sources").Range("AC" & TPLR).Value = Application.WorksheetFunction.XLookup(Sheets("3 Enter Quote Data").Range("F5"), Range("Selected_Vendors[Name]"), Range("Selected_Vendors[SharePoint URL.[MF] Path/Location]"), "X", 0, 1)
Thanks
Method 'Range' of object'_Global' failed
Sheets("Cost Sources").Range("AC" & TPLR).Value = Application.WorksheetFunction.XLookup(Sheets("3 Enter Quote Data").Range("F5"), Range("Selected_Vendors[Name]"), Range("Selected_Vendors[SharePoint URL.[MF] Path/Location]"), "X", 0, 1)
Thanks