Print range of cells to pdf to specified folder saved as a cell value

[Prevost]

Hi There,

I was looking around but could not find a direct answer and I am unsure of the print functions and parameters in VBA. What I would like to do is print a range of cells, say A5:E40, to a pdf using Adope PDF. I would also like the name of the created pdf file to be that of a certain cell value, say C7. How do I go about doing this? I read on a post that because Adobe takes time to print the pdf document, you have to add in a delay timer to the code to allow Adobe to create the pdf, not sure if this is true?

Anyways, any help is greatly appreciated!

Thanks.

 

[Prevost]

My bad. I found it. This prints the first page which works for me. I think I would be able to adjust it to print a certain cell selection on the screen.

Sub Make_PDF()
    Dim pdfName As String
    pdfName = Range("C7").Text
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\100043059\Desktop\" & pdfName & ".pdf" _
    , Quality:=xlQualityMedium, IncludeDocProperties:=False, _
    IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub