I am quite inexperienced in writing macros and I am currently working on a spreadsheet that has a Macro which saves the active sheet as a PDF (see below). What I want to find out is there a way that the height of the rows can change when saved in line with the amount of charcters that have been filled in that particular cell or can this only realy be achieved by the user who is filing the cells in ?


Sub Save()
'
' Save Macro
    
    ' Set Variables.
    SaveFolder = "H:\"
    DocName = Range("S7").Value
 

' Save as PDF
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=SaveFolder & DocName, Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub
Thanks