I'm getting the error Type Mismatch on the following line:
If .Offset(y, 0) = Sheets("Averages").Range("B2") Then
Any clue what I'm doing wrong?
Thanks!
Please Login or Register to view this content.
I'm getting the error Type Mismatch on the following line:
If .Offset(y, 0) = Sheets("Averages").Range("B2") Then
Any clue what I'm doing wrong?
Thanks!
Please Login or Register to view this content.
it would be helpful to see workbook with data that causes error
fixed with "On Error Resume Next"
Hi,
That's not a fix: that means that you are ignoring the error.fixed with "On Error Resume Next"
The cause of the error is most likely that there is an error value (eg. #DIV/0!) in one of the cells. If that's not what you would expect then you're welcome to attach an example for us to look at.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks