Using Pages to define a range is painful from a coding viewpoint. I would recommend you either use selection or a bookmark to define the chosen range.

From the user's viewpoint, what is their thought process in deciding what range the code has to run over? If you are going to prompt them for a start and finish page number, what are they going to need to do BEFORE running the macro in order to be able to answer that question? Can you simplify that decision making process by coding it without asking the users for page numbers?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia