Turning off Help displays in VBA
Posted by CogswelCogs on May 29, 2001 6:55 AM
I am running a program that does numerous analysis.
Every once in a while it hits a blank area. This cause a help diplay question, saying analysis cannot be performed on the particular area.
I have application.displayalerts = false, but this does not seem to apply to these help questioins.
How do I shut them off?
Posted by Spacely Sprockets on May 29, 2001 8:22 AM
It sounds like a error that you wouldn't/shouldn't want to turn off. It seems you need to capture and deal with those blanks programmatically or fill the blanks with pertinent data, even if zeroes will work.
On Error/Resume-Next may be a syntax to look at but without more info, it is a little difficult to address your needs.
Posted by CogswelCogs on May 29, 2001 10:24 AM
Cannot Make them zero because they would then be analysed as a use. Want only results to be included in analysis. Zeros would increase the number of occurences that I analyse and lower avgs so forth. I will try on error, but I dont think its considered an error. Think it is some sort of help display thingie.
