Hello, I have a macro that loops thru a sheet [KEY STATS], entering the name into the sheet names [23 Score] and then populates with the lookups for the individual. Then it will print to a printer and all is good. Using the same technique, i need to be able to run my macro and instead of printing to a local printer, i need to print to a pdf file and have it save, naming it from where it pulls the names in from the loop but every variation I try to use when printing errors out. Any help or suggestions out there? TIA (sample attached).