Saving Worksheet to PDF using VBA

[omagoodness]

Hello again.
I am trying to archive data on a sheet by saving as a pdf file. I have tried 2 different blocks of code and in both cases, the pdf file was created in the predetermined location with the correct file name, however the file was blank. The code did not copy the data.
The first code I used was.

Please Login or Register  to view this content.

The second code I tried was something I found on a tutorial site.

Please Login or Register  to view this content.

Both scenarios resulted in a blank pdf. Any suggestions?

[vba_php]

after very quickly reading results here:

https://www.google.com/search?q=vba+...pdf+file+blank

I would bet more than anything that some of those would fix the issue. but not sure. check them out perhaps? a very wise person answered someone else here:

https://stackoverflow.com/questions/...as-blank-pages


additional info:

https://docs.microsoft.com/en-us/off...tasfixedformat

https://docs.microsoft.com/en-us/off...ixedformattype

[omagoodness]

Thanks. I'll have a look and see what I can find out.

[omagoodness]

I had a look at the links you suggested and you were right, they were very useful. My issue was resolved by setting the print range and adding to the ExportAs line.

Please Login or Register  to view this content.

Thanks again!

[vba_php]

ha ha ha. what a rare case. I'm never right. good for you! =) see ya later.

[omagoodness]

Thanks for the warning. lol