Hi,
Could I please get assistance to get this custom function to work. TX
Help on VLookupAll
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Help on VLookupAll
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Help on VLookupAll
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!!!)
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Help on VLookupAll
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
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Help on VLookupAll
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Help on VLookupAll
You are very welcome(TX for the code Steve!!!)
Steve