I hope someone can help because this is driving me absolutely bonkers. This should be something so easy yet....
I am trying to print a number of pages depending on a cell value which is a value of a formulae
Code:Sheets("GENERIC").Select a = Range("Z1").Value ActiveWindow.SelectedSheets.PrintOut From:=1, To:=a, Copies:=1 Sheets("MAINSHEET").Select End Sub
The whole worksheet has page breaks in it to make 40 pages. Every time the above macro is run it will print 40 pages regardless of the value of (a).
What am I doing wrong?