How Export Selected Area of Worksheet(Active Worksheet) in Pdf by using Macro RRS feed

  • Question

  • Hello,

    I want to save ,selected area of worksheet as format of PDF.

    Area as like in current excel sheet >> A1 : M1 upto A100:M100 ,


    Sunday, September 14, 2014 8:45 AM


  • You can use code like this:

    Sub ExportRange()
        Range("A1:M100").ExportAsFixedFormat Type:=xlTypePDF, FileName:="C:\PDF\Export.pdf"
    End Sub

    Regards, Hans Vogelaar (

    Sunday, September 14, 2014 9:17 AM