Saving to PDF Writer

Hello everyone,

I recorded a macro that runs a For loop through a range in Sheet1. Each cell is individually copied and pasted onto Sheet2 (the values in sheet 2 are dependent on the cell copied/pasted onto it). At each cell in the for loop, I send the file to a PDF Writer. This is where I run into trouble. I have the right destination of the pdf writer, but everytime it wants to save it prompts me for a file name to save as. Since I am running through hundreds of cells, I want to incorporate code that automatically saves without the user having to sit and type hundreds of filenames. In my attempt to fix this, I recorded yet another macro going through the motions of file, print to pdf, save as, etc... but it only records the send to pdf writer part. Does anybody have any ideas how I could incorporate the "save as" part into my code? Thanks in advance.

-- Isaac

I'd appreciate any help and ideas.