I have a macro that prints via a drop-down list.
I want it to save in PDF on this path D: Mareno and not in .PrintOut
thanks in advance.
Sub Impression()
Dim Liste As String, C As Range
With Sheets("Buisness Support")
Liste = .Range("C7").Validation.Formula1
Liste = Right(Liste, Len(Liste) - 1)
For Each C In Range(Liste)
.[C7] = C.Value
Next C
End With
End Sub

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month