Thread: Placing the MsgBox "No ID found" statement in my code??
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default Placing the MsgBox "No ID found" statement in my code??
And the following line...

sIdShts = ",'" & ws.Name & "'!" & rng.Address

..should be...

sIdShts = sIdShts & ",'" & ws.Name & "'!" & rng.Address

...so it preserves existing values!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply With QuoteReply With Quote