How do I write the code below so it works? Currently it deletes all the "B's" in the column when it should only delete 1 or 2 "B"s" that fit the condition. If I write the code one condition at a time without the "or's" in separate macros that call each other it works but that would be a lot of writing.
Please Login or Register to view this content.
Can you upload a file with some data
Group the conditions for the three tested cells in a given row.
Group conditions with parenthesis like this...
Or group conditions with nested IFs like this...Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 01-20-2022 at 01:07 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks Alpha! Good tip on the grouping.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks