If cell a2 is blank if statement

[travis.cook21]

Thanks for any help given. It is greatly appreciated.

I have this code here that works properly. It's saving each sheet as a PDF however I need it to not save the sheet and just skip it if cell A2 is blank. I'm not sure how to code that. Here is my code so far:

Please Login or Register  to view this content.

Thanks for the help!

[davesexcel]

You can edit your original post and add code tags to the code.

AA CodeTags.jpg

[travis.cook21]

You can edit your original post and add code tags to the code.

Attachment 480310

Sorry didn't think that was necessary since it was so simple. It's essentially just selecting a new sheet in a workbook each time and then saving it as a pdf. I need it to not save it if cell A2 is blank (A2 will always be a formula but it may not return a value and will be blank).

Thanks.

[travis.cook21]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thanks. Do I have it correct now?

[AlphaFrog]

Please Login or Register  to view this content.