Looping through name range and create one pdf instead of individual pdfs

[igoodable]

My current code loops through each item in range and creates a PDF for each, can someone show me how to create one single PDF?

thanks!

Please Login or Register  to view this content.

[tim201110]

you can copy a sheet each time, copy values in used range, then select all of them and print pdf