hey guys, how do i suppress this error message? i already tried application.displayalerts = false and added on error resume next, but when i run the code (F5), once it hits the errors it exits.
i'm trying to delete all the named ranges in excel
Dim x As Integer
x = 1
Application.DisplayAlerts = False
On Error Resume Next
For x = 1 To 100
Application.DisplayAlerts = True
i tried do until err<>0 but the same problem still happens - once it hits an invalid reference it stops. thanks guys!!