microsoft.public.word.vba.general

Something like this might help

Stop = 0
For Each varRow In myXL.Worksheets("File").Cells(1,1).CurrentRegion.Rows
...
stop = stop + 1
if Stop = 100 then
exit for
end if

Next varRow

This stops after processing the first 100 rows ins the sheet.
-------------------
S. Hewes


"cagreer@att.net" wrote:

> 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.
>