largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
I'm new to UDFs, is it possible to have a UDF for a vlookup that references a closed workbook?
I have:
I have:
Code:
Function CCLookup(Rank)
CCLookup = excel.application.worksheetfunction.vlookup(Rank, 'O:\C\Templates\[UDF Lookup Sheet.xlsx]Sheet1'!R2C1:R676C5,2,false)
This is not working and I've read a few other posts that seem to suggest it's not possible to do a lookup with a closed workbook directly in vba. Any workarounds?