VBA Code for deleting automatically entire row.

[Joao Mbachi]

Hi I Have spreadsheet containing data with conditional formatting on column "G" Is it possible to create a VBA code to Delete the entire row when on the column "G" displays "Completed".

Your help will be much appreciated.

Thanks

[YasserKhalil]

Hello Try this code

Please Login or Register  to view this content.

[Fluff13]

Another option, if the values in col G are actual values, rather than from a formula.

Please Login or Register  to view this content.

[scottiex]

Maybe you want it to delete automatically, if so then try

in the worksheet module

Please Login or Register  to view this content.

[Joao Mbachi]

Hi It works but I would like this functionality to delete automatically, once the complete word is selected.

Thanks

[YasserKhalil]

So you can use the code in post #5 and replace Change with SelectionChange

Please Login or Register  to view this content.

[Fluff13]

This will delete the row once you enter Completed

Please Login or Register  to view this content.

[daboho]

Please Login or Register  to view this content.

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.