VBA Question

[cesymcox101]

I have inherited a macro-based file that has a radial button to convert the active sheet to a pdf. the issue is that it keeps debugging out on the saveaspdf macro. the code is listed below.

Worksheets(selectsheets()).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=ThisWorkbook.Path & "\" & Worksheets("Update Data").Range("D22") & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True

Welcome any solutions.

 

[Micron]

Can't tell from that which line causes the error. Try stepping through the code & checking variable values after the line is executed. Or substitute values for variables such as file path. Check that arrays have elements and are not empty, or that in a loop you're not going higher than the number of array elements, especially if the array is zero based.

Better to post code within code tags, using vba icon on posting toolbar rather than posting pics. Hard to read.