Help: Defining a variable with an array of worksheets that use the same range

I'm trying to get VBA to save each worksheet I have defined in my array as a seperate PDF file.

I keep getting error 438, Object does not support this property or method.

I'm a noob to VBA and have been trying to figure out all this stuff, but I can't seem to understand this...


Here's my code:

Please Login or Register  to view this content.

DT Lien Waiver Template Xcel.xlsm

Hi Paulw793, try it

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

nilem,

The first one worked the first time! Thanks!

Is there any way to make it not create a pdf for worksheets that are null for I6?
Like an if...then?

Please Login or Register  to view this content.