Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Multiple worksheet named ranges to PDF
1 view
Skip to first unread message
Cresta
Dec 3, 2007, 10:36:10 AM12/3/07
to
Hello
I have been given the task of exporting multiple named ranges from different
sheets to a pdf file.
I have been given the task of exporting multiple named ranges from different
sheets to a pdf file.
I can do it from a single sheet with many ranges using the following code
Range("A8:G19,A83:N96").Select
Selection.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"c:\filename.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True,
IgnorePrintAreas _
:=False, OpenAfterPublish:=True
Could anyone point me in the right direction for ranges on differnt sheets.
Thanks
0 new messages