In a range from D2:D50 there will be page numbers. They can be random (i.e. - 2, 3, 5, 10, 11, 12, 15, etc...). What I am trying to do is run a loop script on this column of numbers, once per number, until it reaches the end. Can someone please fill in the blanks for me on this one?
Sheets("All Trip Sheets").Select
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
I don't know how to do "Do..Loops". The basic function I'm trying to accomplish is to copy and paste the page number from "All Data" into the "All Trip Sheets" page, into merged cell H2:I3. It will then print that page and move to the next number in the list.