VBA script that saves excel range as pdf

Question

I tried implimenting a range into my code, but I'm having no luck. I'd like to be able to have a script in vba to 'save as' a specific sheet or specific range to pdf. Any help would be much appreciated.

Here is what I've been working with:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "c:\Book1.pdf", Quality:= _
    xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=True

Thanks,

Answer 1

you have the code, just use a range instead of activesheet

e.g. Sheets("Sheet1").Range("B2:H28").ExportAsFixedFormat ...