cycle through data validation list to print to pdf and save as cell text

[daikeda]

Hi,
I have:
- worksheet name("test1")
- data validation list in "A"
- print range is first page of worksheet or A1: I45

looking if there's a way to have macro that cycles through the data validation list and prints a PDF with the name of the text in that cell and loop through so every item of list prints as their own pdf. aka if there's 100 lines in the drop down, then i'd end with 100 pdfs each individually named for the 100 drop down options.

 

[maxpit]

Hi Carla carla,

before the first instruction "Dim destinationFolder As String", which you reported, can you share what other lines of code are there?

Bye

 

[Carla carla]

Looks like you just quoted my post, but didn't add anything new to it.

As I said, you are missing the procedure declaration line, that begins with "Sub..." or "Private Sub"!

If you look at the code in post #2, you can see it at the very top:

Sub Create_PDFs()

I recommend you read some articles on how to write/create VBA code to gain a better understanding of the requirements, like this one here:

What is a VBA Procedure, Sub Procedure, Function Procedure?

What is a VBA procedure, how to declare a VBA procedure, how to name a VBA procedure, what to type inside a VBA procedure?

www.emagenit.com

Hello, thank you. I got it.