Modify a macro that creates PDF file from the print area on a worksheet!

[A440]

Hi

THis is taken from a macro I use to create a PDF file from the print area set on the sheet and attaches it to an email in Outlook..

What I would like to do is, based on cell Y4 containing 1 or 2 is to change the print area from $B$1:$M$53 to $B$1:$M$88.

Is there anything simple that can be changed to do this?

"ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=OpenPDFAfterCreating"

Thanks

[davesexcel]

Nice little IIF () statement should do the trick.

Please Login or Register  to view this content.

[A440]

davesexcel, Many thanks for your code,perfect