Hello,
I'm trying to create a macro that will clear contents of cells if they do not meet multiple criteria.
For example,
Say column N is filled with various letters of the alphabet - 1 letter to each cell. I need help with a macro that would clear the contents of the cell if it is not equal to A, B, C or D. Note that column N would also have a header that should NOT be deleted.
Thank you.
I'm trying to create a macro that will clear contents of cells if they do not meet multiple criteria.
For example,
Say column N is filled with various letters of the alphabet - 1 letter to each cell. I need help with a macro that would clear the contents of the cell if it is not equal to A, B, C or D. Note that column N would also have a header that should NOT be deleted.
Thank you.