I have a Macro which outputs the active sheet as a PDF. I want to change the macro so that it asks for page numbers everytime i output the PDF (example from sheets 9 to 12). How should i proceed?. Thank you guys in advance @Deepak