hi
can anyone help on setting a print area on a hidden sheet for a range
sheet name is Names and the range would be A1:K10
this would then let me choose which printer to send the selected range to.
This is what i would like to use but on a hidden sheet.
the reason i need to be able to select a printer is that there are several printers on the network.
Sub sendprin() Worksheets("Names").PageSetup.PrintArea = "$A$1:$k$10" End Sub
Bookmarks