Delete Blank Rows Code If No Parts

Hello,

On my AFRsInput sheet there is a red shape to delete blank rows from Table1 (O:Q). If there aren't any parts and it is selected it goes to debug. Can the code be modified to exit code if there aren't any parts?

Thank you

Please Login or Register  to view this content.

Here is the attached workbook.

Brilliant! Thanks again for your valuable help.

Is there a fail safe for the Add More Rows in there aren't any parts yet? What I would like is to add as many rows to enter parts as needed then type them in.

There is a code for 'Add More Rows' (green shape on the AFRsInput sheet).

If pressed and there aren't any parts it puts the word 'new' in column O. Not sure why that is there. I want to press it multiple times for as many parts as I need then type the parts in.

Is it possible to modify that code?

The code:

Please Login or Register  to view this content.

Wow you are amazing at this! I really appreciate the help

Have a wonderful day ahead!