Hi,

I don't think any of us know what you mean by watermarking a certain number
of names. Here is my, probably improper, take on this - you want a watermark
on the three Excel sheets which displays a given name and you want to produce
a set of 3 pages for each with each of the names you have somewhere else?

If you mean a true watermark in Excel then you are going to have to have a
graphic file for each name because so Excel can use each one and them got to
the next. The only way to put real watermarks in Excel is to use page size
graphic files.

--
Thanks,
Shane Devenshire


"mcp201" wrote:

I have 3 sheets, each displaying different data. I have x amounts of names
that I would like watermarked on each page. I wanted to know what would be
the easiest way in writing Visual Basic to print each name in PDF with all
three sheets. Thanks in advance.