Your post makes no sense. I have given you two macros that will work equally well - with or without wildcards. Simply telling me that part of your code is for non-wildcards doesn't for a moment explain why you're using it or, if it's needed, why you don't just change the data source.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]