I changed the view in an attempt to speed up the macro because you said the earlier one was very slow. I didn't do any speed tests because I didn't have a big file to test on but in theory, this should help the macro run faster because it reduces the repagination load.

You can disable that line up at the top of the macro. Or add a line to return the view the page view at the end of the macro.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia