antonywalsh
New member
- Joined
- May 8, 2012
- Messages
- 10
- Reaction score
- 0
- Points
- 0
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
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?
Thanks
I am trying to print a number of pages depending on a cell value which is a value of a formulae
Sub PRINT_GENERIC()
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?
Thanks
Last edited: