Cant Figure Out How To Detect Which Cells Have Type Mismatch Errors & Correct Them

[Genus Max]

Hi,

I'm trying to get VBA to detect which cells have Type Mismatch Errors, & correct them. But nothing seems to work. I've tried adding Application.DisplayAlerts = False, but it still displays the error message.

I've also tried Iferror & Iserror, & On Error, none of them seem to work on Type Mismatch Errors... I'm obviously doing something wrong here ...

The text im getting a Type Mismatch Error is 9.329.61, this is located on cell A1.

Please Login or Register  to view this content.

[dangelor]

The value in A1 is a string (2 decimal points) and you declared the n variable as a long integer. Change one or the other.