HI ALL
i this code to save my sheet as a pdf using info from cell c2
Private Sub CommandButton1_Click()
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
filename:="C:\release" & Range("C2") & ".pdf", _
OpenAfterPublish:=False, _
IncludeDocProperties:=True, _...