small printer

[Guest]

I frequently have a need for just a small section of a spreadsheet to be printed and don't want to waste an entire sheet of paper. a 3 inch wide receipt printer would work well. And can i set the large printer as my default printer, and write in a macro to switch to the other printer and print a particular range ?

 

[Gord Dibben]

Bear

Turn on the macro recorder when changing printers.

I got this code when recording.....

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 7/22/2004 by Gord Dibben
'

'
Range("A117").Select
Application.ActivePrinter = "HP DeskJet 1200C/PS on LPT1:"
Selection.PrintOut Copies:=1, ActivePrinter:="HP DeskJet 1200C/PS on
LPT1:" _
, Collate:=True
End Sub

Gord Dibben Excel MVP