Hi all,

Apologies if this has already been covered, I've tried searching but cannot find what i need. I am a complete beginner to VBA but hoping someone could help me with some code to create a PDF in the same folder as the excel file with the file name being the contents of cell A1 (which will contain a formula combining some text and a date).

Thanks in advance!