Hi, I have a table (Table1) with data like this below. With VBA, how can I just ignore the errors that occur (Inconsistent Calculated Column Formula)? I am browsing and maybe use statements, like For-Each-Next but I don't know how to do that. Thanks
Thanks for your answer. I tried your code and work properly. But I modified your code, use Error number 9 instead 4.Something like this.
VBA Code:Sub IGNOREINCONSISTENT() Dim r As Range: Set r = Range("Your Range") Dim cel As Range For Each cel In r cel.Errors(4).Ignore = True Next cel End Sub