I have an Excel workbook, I want to be able to print from one worksheet using a command button, but I also want to print a specific number of pages that will always range from page 1 to a number that is embedded in a cell on that sheet to print. The worksheet that is to be printed is already formatted so that each page will print correctly, but it has over 100 formatted pages, but may not always have data to print out on every page, so the range will always be different to print. I have knowledge in VBA and I know how to create a command button, but with this, the command goes to the worksheet to print but then returns to the worksheet the command button is on and prints that page. I thank you in advance for any/all help given.
Kenneth