Interesting. I obviously never thought of that. I'm in the middle of
a big project (which is what I was hoping to apply this pivot table
thing to), but after that is done in a couple weeks, I'll grab this
and modify my current process. I appreciate the tip and explanation.
Thanks for all your help trying to solve this. If I do happen to come
up with a decent work-around, I'll post back just as an FYI. Thanks!

Frank

Always glad to help...
Best Wishes!

--
Garry

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