Hello
please i need your help
I am trying to create VBA to delete the row on a Worksheet named "Sheet1" when the value of the cell in Column G contains X
so example value in Cell G3 = X, therefore row 3 should be deleted.
The number of rows can vary with a max of 100 lines
Thank you.
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 04-16-2024 at 10:27 AM.
Bernie Deitrick
Excel MVP 2000-2010
Bernie Deitrick
thanks for your help
But VBA is not auto running when data is entered directly in the cell
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter an uppercase "X" in column G and press the ENTER" key.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Yes!
That worked perfectly.
Thank you very much Mumps1.
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks