VBA Code to Delete All Blank Rows in Table

**fredfarmer** · 03-26-2019, 10:22 AM

Hi,

Can someone derive a macro to delete the blank rows in the Parts table (O:R) on the AFRsInput sheet while the sheet is under protection?

Thanks,
FF

**bakerman2** · 03-26-2019, 10:31 AM

You can't. You will have to Unprotect, Do your stuff, Protect.

Edit:
When putting this in thisworkbook you don't need to Unprotect, Protect.

Please Login or Register  to view this content.

**fredfarmer** · 03-26-2019, 10:34 AM

Thanks I have the code to add rows can this be adjusted to delete:

Please Login or Register  to view this content.

**YasserKhalil** · 03-26-2019, 10:52 AM

Try this code

Please Login or Register  to view this content.

**fredfarmer** · 03-26-2019, 10:57 AM

Perfect YasserKhalil thanks so much!

**YasserKhalil** · 03-26-2019, 10:58 AM

You're welcome. Glad I can offer some help
Regards

VBA Code to Delete All Blank Rows in Table

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to Delete All Blank Rows in Table

Re: VBA Code to Delete All Blank Rows in Table

Re: VBA Code to Delete All Blank Rows in Table

Re: VBA Code to Delete All Blank Rows in Table

Re: VBA Code to Delete All Blank Rows in Table

Re: VBA Code to Delete All Blank Rows in Table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need help please with code to delete rows where a specified cell is blank

[SOLVED] VB Code to delete blank rows

[SOLVED] VBA code to delete rows that are blank

[SOLVED] VB Code to copy and delete blank rows

Changing code from deleting rows to cut/paste rows into another sheet and delete blank row

Code to delete all blank rows and add totals

Delete rows if column contains a blank code included

Bookmarks

Bookmarks

Posting Permissions