This is the code im using, i think i got the base from it from this forum then i have just changed it to fill my needs
1. "ToPrint" is the range of cells that the code should loop through
2. The Line1 Line2 i only use because sometimes my cells is empty or have a "-" in it and if it does i just want it to continue to the next cell
3. the filepath to your pdf reader you have to set yourself
4. The paths for the "temp" printlog you have to change to your choice of filepath
Let me know if you wondering about something
Bookmarks