So I have a vlookup in VBA which refers to a tab in the activeworkbook :
Now I want this formula to be flexible to name changes of the workbook.Please Login or Register to view this content.
So I thought about :
This obviously does not work.Please Login or Register to view this content.
Can it be tweaked to work or should an entire different approach be used?
Bookmarks