Hi all,
I am getting myself crazy with this one as I'm sure I've done it before, but I can't for the life of me workout how to return a value from a table on another worksheet using VBA.
I have drafted something like this:
txt_Currency = Application.WorksheetFunction.Index("Supplier[Currency]", Application.WorksheetFunction.Match("name", "Supplier[Supplier]", 0))
Is there a clean way of returning a value from index matching a table?
Thanks
Bookmarks