Perfect!!! That's amazing....I can't thank you enough. This is going to save so much time.
REALLY appreciate it.
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.