Macro to save as pdf with auto-filename from cells

[guscrouchend]

Hi,

I would like to create a macro to save the current worksheet as a pdf, with filename "C3.I2" - i.e. the contents of cell C3 and I2.

I have Adobe PDF save as option.

Help much appreciated

gus

 

[BrianB]

You may be interested in this

http://www.mrexcel.com/forum/showthread.php?t=462786

 

[guscrouchend]

Thanks Brian that's great