Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing to PDF question
The below works (thanks to Ron De Bruin) - but is there a way to print a range without making the sheet that it is in active? Sub CreatePDFRates() shtAssum10.Select Dim FileNameStr As String FileNameStr = "\\Spipfile04\dowb1$\2008\annuity\Individual_Illus trator\" & shtAssum.Range("I39") & ".pdf" shtAssum10.Range("B1:N35").ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=FileNameStr, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ OpenAfterPublish:=False End Sub -- Wag more, bark less |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Question | Excel Discussion (Misc queries) | |||
printing question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Programming | |||
Printing Question | Excel Worksheet Functions | |||
Printing Question | Excel Discussion (Misc queries) |