-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
data mismatch
-
Highlighting data mismatches in tables by row
I have tried =$A1<>$B1 but this only looks at two cells at a time. =$A1:A5<>$B1:B5 does not work. Ideally I would like Excel to check for differences between two tables row by row and highlight them. If not then at least return True/False for a range. I have a lot of data to sift through! I...- angeloudaki
- Thread
- data analysis data mismatch
- Replies: 10
- Forum: Excel Questions
-
K
Date Error 13 when Pulling from Blank Cell
When I run this code it works for each iteration of the loop until the duedate pulls from a blank cell. How do I fix this or make it so it skips blank cells? It gives "Runtime Error 13 Data Mismatch" Sub CreateTask() Dim olApp As New Outlook.Application Dim olName As Outlook.Namespace Dim...- Kirexin
- Thread
- data mismatch date duedate error 13
- Replies: 3
- Forum: Excel Questions
-
H
VBA-using different data types in an iif statement
Good Morning, I've built a query in Access and am have a data type mismatch in an IIF statement. I know where the problem is but I don't know how to fix. Last night, two of us worked on for 4 hours. Ugh! When I use each part of the IIF statement separately, they work. I cannot put them...- HappyLadyToo
- Thread
- access calculated field data mismatch iif statement vba
- Replies: 4
- Forum: Microsoft Access
