Hi All,

I have a spreadsheet for sports stats, where I run two macros to show information for a particular team match-up.

Once the information for the two teams is displayed, I would like to utilize a macro(s) to be able to print selected areas of the worksheet to a PDF, copying the details of a nominated cell (say A1) to use as the name of the PDF. The details of this particular cell change depending upon which teams are displayed.

This is easy enough to do manually, however I am unable to replicate what I do manually via a macro. Is there any way of copying the details within the nominated cell and using this to name this file as part of the print to PDF process.

Any assistance would be greatly appreciated.

Thanks,

Mr N