Hi Garry, hi Howard,
Am Tue, 06 May 2014 13:13:34 -0400 schrieb GS:
Good catch! Should be...
sMsg = sMsg & Join(Split(Mid(sIdShts, 2), ","), vbLf)
..to remove the leading ","!
if you want all matches be listed you must change:
sIdShts = sIdShts & ",'" & ws.Name & "'!" & rng.Address
Regards
Claus B.
Hi Claus,
I guess you didn't see I already caught that one, but thanks just the
same!<g
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion