New to VBA: what script to write so that a file is not saved if there's no payments?

Hi,

I'm very new to VBA/ Macros so i'm not quite sure how to word it out but at the moment, in our workbook, if there's no payment a file is still automatically saved to our shared drive despite it being empty.

This is the current script we have. What do I add or amend in order to fix this? I don't want it a file to save in our shared drive if it's empty.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Welcome to the Forum ericinfo13!

What do you mean by "empty"? It doesn't appear that you mean the file is literally completely empty. What is the condition that indicates that there is no payment?