Forum Discussion
Difficulty matching cell values
Hello, I have made a VBA macro that reads cell values into an array and compares with values in another array. If there is a match, an action is taken (not relevant). It works with some exception...
Could it be that one value is a number and the other is text that looks like a number?
Thanks Hans, but that not it. I tried it. I tried different kinds of cell formatting (text, number, general). All cells have the same formatting. HansVogelaar
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
