It is not really clear what you mean by "stop at a location". How would
that location be defined?
Suggesting a modification to your exisiting code would be easier if you
showed us what it was.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
news:e7f0eeba-eb0c-4d48-b2ee-640b81cfd560@s37g2000prg.googlegroups.com...
> built a macro in word to bring data from an excel worksheet. Is there
> a way to have word merge stop at a location instead of searching the
> full excel sheet. Have used first & last 1 & 50 still goes the
> limit.This is being done in 2000 as the people who will use after I am
> gone are novices as I am. This is really my last hurdle to this
> project.
> Thanks to anyone who can speed up this merge.