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