Using data in a cell to create a PDF in VBA

[Frankietheflyer]

Hi Folks
I want to call various sheets and ranges for printing to PDF depending on certain factors. I've managed to build a code that places the relevant Sheet and Range information into a cell (cell is at "Sheets "Race Meeting Information").Range("DZ1")") and refer to the cell as "DZ1Range". (Set dz1Range = Sheets("Race Meeting Information").Range("DZ1"))

I now want to place whatever is in cell DZ1 into the code to produce the PDF so avoiding having many repeat codes for each different sheet & Range.

I have proved DZ1 holds the correct info by putting a "MsgBox DZ1Range" in the code which shows the correct sheet and range required.

I've tried many machinations of the following code

ThisWorkbook.DZ1Range.Value.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=myFile, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True

But none are successful.

How can I get the code for producing a PDF to use the address at DZ1Range ??

Thanks in Advance!