Help on VLookupAll

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Help on VLookupAll

Post by Rudi »

Hi,

Could I please get assistance to get this custom function to work. TX
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Help on VLookupAll

Post by Rudi »

Sorry,

I got it working. My silly error!!!

PS: There was syntax errors in the source code on the Windows Secrets Site. Also two End IF statements were missing. I managed to rectify this in the module in the attached workbook. (TX for the code Steve!!!)
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
User avatar
HansV
Administrator
Posts: 78391
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Help on VLookupAll

Post by HansV »

Lots of code on the Windows Secrets site has been mangled during the conversion to newer software; unfortunately the new management hasn't bothered correcting this.
Best wishes,
Hans
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Help on VLookupAll

Post by Rudi »

It was major mangled...Istent a good 10min entering to break the code over its lines... Good practice :)
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
User avatar
sdckapr
3StarLounger
Posts: 392
Joined: 25 Jan 2010, 12:21

Re: Help on VLookupAll

Post by sdckapr »

(TX for the code Steve!!!)
You are very welcome

Steve
Top

Return to “Excel and other spreadsheet applications”