asked on
how to suppress error message excel vba
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.
![error pop up]()
i'm trying to delete all the named ranges in excel
Sub test()
Dim x As Integer
x = 1
Application.DisplayAlerts = False
On Error Resume Next
For x = 1 To 100
ActiveWorkbook.Names(x).De
Next
Application.DisplayAlerts = True
End Sub
i tried do until err<>0 but the same problem still happens - once it hits an invalid reference it stops. thanks guys!!
i'm trying to delete all the named ranges in excel
Sub test()
Dim x As Integer
x = 1
Application.DisplayAlerts = False
On Error Resume Next
For x = 1 To 100
ActiveWorkbook.Names(x).De
Next
Application.DisplayAlerts = True
End Sub
i tried do until err<>0 but the same problem still happens - once it hits an invalid reference it stops. thanks guys!!
Microsoft Access
Last Comment
developingprogrammer
It's better to write code that avoids errors by design as much as possible. Is the error occurring after all worksheets are deleted?
Instead of using 100 as an upper limit, use the number of worksheets.
Application.worksheets.cou
Instead of using 100 as an upper limit, use the number of worksheets.
Application.worksheets.cou
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Sorry you're dealing with named ranges.
I'm not an Excel expert, but does this get the total count?
ActiveWorkbook.names.count
I'm not an Excel expert, but does this get the total count?
ActiveWorkbook.names.count
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionSOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
whao guys, no points wanted and researching an unfamiliar topic just to help me, i'm really touched and appreciative of how yall take the time to help me out in the problems i face. maybe i'm a bit naive but i definitely couldn't imagine someone going out of the way to help their fellows or someone they don't know - i'm really appreciative guys = )
pratima thanks for looking into this but i think docmd is for Access not Excel, i tried it in Excel and it couldn't work - not found in the object library. but thanks! = )
pratima thanks for looking into this but i think docmd is for Access not Excel, i tried it in Excel and it couldn't work - not found in the object library. but thanks! = )
<whao guys, no points wanted and researching an unfamiliar topic just to help me, i'm really touched and appreciative of how yall take the time to help me out in the problems i face.>
...In my case, I only posted a very basic example of a generic error handler.
In other words, ...any expert here could have posted the same thing...
(No research needed)
My post did nothing to actually "answer" your question, it was just extra info.
In the end, and to be honest, ...I have done well this year "point-wise", so I saw no reason to appear greedy for a simple post like that.
So AFAICT, you can still request that my post be removed from the points split.
..."There will always be another Question"
;-)
Jeff
...In my case, I only posted a very basic example of a generic error handler.
In other words, ...any expert here could have posted the same thing...
(No research needed)
My post did nothing to actually "answer" your question, it was just extra info.
In the end, and to be honest, ...I have done well this year "point-wise", so I saw no reason to appear greedy for a simple post like that.
So AFAICT, you can still request that my post be removed from the points split.
..."There will always be another Question"
;-)
Jeff
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ha thanks for being generous jeff, and it's not so much that you didn't answer the question but rather you took time to read through my question and add that info there so i can learn. so it's really much more of your time spent contributing that i want to show my appreciation for = ) thank you!! = ))
Good Luck in the New Year!
;-)
Jeff
;-)
Jeff
ASKER
thanks Jeff! = )
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
DoCmd.SetWarnings False
refer
http://www.mrexcel.com/forum/microsoft-access/89057-can-you-supress-display-alerts-via-visual-basic-applications.html