Posts by EH73

Perfect!!! That's amazing....I can't thank you enough. This is going to save so much time.

REALLY appreciate it.

Ultimately cells A3, A4, and A12:H20 (although that's not obvious as I've removed commercial info).

Attached with code. Sheet entitled "Main" is a basic version of the one I want to save to PDF,

See attached. I changed A1 to B6 in the code but no other changes.

Thanks Roy, really appreciate your help.

I get an application-defined or object-defined error when I run that and debugger points me towards this line of code.

str = TargetCl.Validation.Formula1

Thanks Roy,

The list is stored in a sheet in the same workbook so easy to use.

New to VBA so would appreciate help on a particular Macro I'm trying to set up.

i have a worksheet which changes based on the value selected from a drop down list in a specific cell.

I want to write a macro that saves the worksheet as a PDF, selects the next value from the data validation list, repeats the save and so on until the full list of values is exhausted.

I have a SAVE PDF Macro but can't manage to add to it to get it to loop through this process for each value on the list.

Sub SavePDF()
'
' SavePDF Macro
'


'
ChDir "XXXXXXXXX"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=Range("V2").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub