I am trying to compare cell values for data validation.
One of the cells is a column header in a pivot table, and the other is just a cell. Each contains a word, and should be the same.
I tried using this code
But I always get the error message, even if I know the cells match. I've also tried dimensioning the cells as integers.![]()
Please Login or Register to view this content.
Why won't Excel recognize they equal the same thing?
Thank you in advance!
Bookmarks