Like I asked before.., how/where does the code find/get the IDs to
search for? IOW, (1st & foremost) they must be available to code by
some method!

Also, you've reverted back to using UsedRange which will take longer
depending on its size. Meanwhile, I've been working toward something
more 'reliable' for results from entering only 1 ID. Not a problem to
do several IDs using arrays, but I recommend a 2D output array to
avaoid limitations of the Transpose() function (should that happen)!

I like the idea of giving the search range a local defined name because
if its RefersTo uses absolute refs then its location auto-adjusts when
columns are inserted/deleted. That means it doesn't need to be the same
column index on every sheet being searched, AND the search can be
limited to only sheets with that named range!

--
Garry

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