I am trying to do a lookup function but it does not compile error occurs at this line:
Could someone please help?Please Login or Register to view this content.
Please Login or Register to view this content.
I am trying to do a lookup function but it does not compile error occurs at this line:
Could someone please help?Please Login or Register to view this content.
Please Login or Register to view this content.
Thread moved to VBA section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
When you declared the myarr variable, you declared it as a string rather than an array that contains strings.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
many thanks works perfect now
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks