Type Mismatch Error?

**PunPryde** · 02-16-2011, 02:33 PM

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.

**watersev** · 02-16-2011, 03:23 PM

it would be helpful to see workbook with data that causes error

**PunPryde** · 02-16-2011, 03:25 PM

fixed with "On Error Resume Next"

**Colin Legg** · 02-16-2011, 05:58 PM

Hi,

fixed with "On Error Resume Next"

That's not a fix: that means that you are ignoring the error.

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.