That is my code that Im trying to use.Please Login or Register to view this content.
This is the crux of the issue. It reappears 3 times for different if lookups, they all fail.Please Login or Register to view this content.
OC_FV.xlsx is the file name, '[plant.model database.xlsx]In Use'!$H3 contains the plant code which correlates to the tab label in the oc_fv file.
I could possibly search through every tab, but thats rather inefficient I think. On the other hand, if the OC_FV file changes, Im guessing excel edit links will not be smart enough to realize this exists to update.
Bookmarks