Hi Rick, such a god-sent! This VBA is marvelous
Can I follow this up by asking if this can be a lookupconcat UDF for multiple criteria?
Type: Posts; User: herman925
Hi Rick, such a god-sent! This VBA is marvelous
Can I follow this up by asking if this can be a lookupconcat UDF for multiple criteria?
Hi Rick, thanks for the help. I do still have some trouble with this code.
It will produce the word 'and' for even cells that only contain 1 name.
So for my example I gave previously, it worked...
Rick, this is digging up old posts, I know. But this VB really saved me so much trouble.
I do have one need from this code though, that is, to add 'and' for the last two sets to variables looked...