Greetings, Gurus.
I have a script designed to prompt you to open a workbook, giving you a selection box to use, and then perform a vlookup from the workbook you selected. I have set all my variables, but there must be some issue with my formula. Although the script enters the correct formula it prompts you twice more to open the workbook before entering the formula. Script below, with comments. Thanks in advance for any help you can offer.
Please Login or Register to view this content.
Last edited by hutch@edge.net; 06-13-2016 at 04:27 PM.
You can't put a VBA variable in the middle of a formula like that. You need:
Please Login or Register to view this content.
Fixed me right up. I thought it was something like that, but I tried every combination of the "" & "" I could think of and kept getting an error. I appreciate your help. This thread is SOLVED!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks