hello
I search for a way to save my file as pdf without any empty rows but the empty rows it locates in this range A23:G34 so any empty rows are in this ranges should not show when save file as pdf
I search for a way to save my file as pdf without any empty rows but the empty rows it locates in this range A23:G34 so any empty rows are in this ranges should not show when save file as pdf
VBA Code:
Sub Save_PDF1()
Dim Nm As String
Dim Rng As Range
Set Rng = Range("a1:g44") '<- Set your range here
Nm = ActiveWorkbook.FullName
Nm = Left(Nm, InStrRev(Nm, ".") - 1) & Format(Now, " yyyymmddhhmmss") & ".pdf"
Rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Nm, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=True, OpenAfterPublish:=True
End Sub