'// Print the selected page
ActiveSheet.PrintOut From:=1, To:=5, _
Copies:=1

My workbook calculates the total number of pages automatically and that
number is in cell 'G6' i need the printout code to pick up the value in cell
'G6' for the "To:". for example cell G6 =6, how do i get the value 6 to
automatically go in the formula.

--
help a friend help you