Hi,
I have this code that I can't undo or do a copy and paste action:
Is there some way to make it work?
I only want that code to run when I sort my columns but it seems to be running with every change I make on my sheet.
Thanks in advance!
I have this code that I can't undo or do a copy and paste action:
VBA Code:
Private Sub Worksheet_Calculate() ' Ignore Errors after Sorting
Dim r As Range: Set r = Range("A2:AS200")
Dim cel As Range
For Each cel In r
With cel
.Errors(8).Ignore = True 'Data Validation Error
.Errors(9).Ignore = True 'Inconsistent Error
.Errors(6).Ignore = True 'Lock Error
End With
Next cel
End Sub
Is there some way to make it work?
I only want that code to run when I sort my columns but it seems to be running with every change I make on my sheet.
Thanks in advance!