Thanks for the suggestion. I probably should have been a little more clear
with my need here. I would like the macro to select a range to be printed to
a PDF file using an Active Cell content as the filename, then save to a PDF
without input from the user. I have no problem doing this to an HTM file
using the Publishobject routine, but too many email servers remove HTM
attachments.

Thanks Again.

"Vasant Nanavati" wrote:

Perhaps you want:

Range("C6").Select

(I haven't looked at the rest of the macro.)
--

Vasant

"Scott Zierler" <Scott wrote in message
...

ActiveCell.Select = ("$C$6")<<<ERRORS OUT HERE