idlewyld89
New Member
- Joined
- Jun 10, 2018
- Messages
- 23
Alright, so this isn't (or shouldn't be) difficult, but it's just one of those things...
I've already referenced several posts/sites along the same lines of this topic, but for whatever reason just can't seem to get this down. As the title suggests, I am (in VBA) referencing a dataset from a closed file. The file does not move, and the pertinent details are below:
File Name: GM Directory.xlsm
Sheet w/ dataset: Area - GM (FSM)
And the code that SHOULD provide the reference:
Range("B2") = "=VLOOKUP(RC[2], ('C:\Users\usraccnt\Desktop\[GM Directory.xlsm]Area - GM (FSM)'!GM_Directory[#All]), 5, FALSE)"
Range(global_findRange("B2")).Select
Selection.FillDown
In case it's useful, global_findRange is a separate function that determines the end of the active dataset so as to allow the "filldown" function to only fill through the last row.
Who will spot my glaring mistake!?!?
I've already referenced several posts/sites along the same lines of this topic, but for whatever reason just can't seem to get this down. As the title suggests, I am (in VBA) referencing a dataset from a closed file. The file does not move, and the pertinent details are below:
File Name: GM Directory.xlsm
Sheet w/ dataset: Area - GM (FSM)
And the code that SHOULD provide the reference:
Range("B2") = "=VLOOKUP(RC[2], ('C:\Users\usraccnt\Desktop\[GM Directory.xlsm]Area - GM (FSM)'!GM_Directory[#All]), 5, FALSE)"
Range(global_findRange("B2")).Select
Selection.FillDown
In case it's useful, global_findRange is a separate function that determines the end of the active dataset so as to allow the "filldown" function to only fill through the last row.
Who will spot my glaring mistake!?!?