I require a UDF in VBA to vlookup a value (named Rnage value) from the activesheet and return a value from a range (Table array) in a hidden sheet in a hidden open workbook.
I can do this with a formula in a cell.
But unsure of a VBA solution.
I would appreciate your help.
Thanks
Last edited by wotadude; 11-17-2008 at 12:13 AM.
Hello wotadude,
In your title you mention using Vlookup on a Closed Workbook. However, your post indicates it is open, but hidden. You should amend your title to match your post. I have found if people are confused by a post, they usually don't respond.
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks