MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, not full row, just delete cell with Shiftup)
We can tell it to delete more than 1 column, change Cols2Delete
DeleteAllOccurances will delete all cells with that item, keep doing that until that item no longer found in that col

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Linkedin Login

SearchFor, InCol, Optional Cols2Delete, Optional DeleteAllOccurances, Optional Wb, Optional Shee, Optional StartFromRow

Views 3,281

Downloads 1,313

CodeID
DB ID