Application.ScreenUpdating not working

[jawbonium]

I have a pair of weird errors here. The first is an error that I get with .Borders. I pretty much gave up on trying to fix it as it really wasn't that important and it was only occuring periodically. Thus I wanted to have the .Borders line execute when it could and suppress the error message when it couldn't. I inserted the following before my .Borders line:

Application.DisplayAlerts = False

and

Application.DisplayAlerts = True

after. However, the error message IS NOT being suppressed! GAH! Any ideas on why?

 

[Chattin]

AFAIK Application.DisplayAlerts hides xl messages and not code errors. Try using an error handler for your code

e.g.
Sub test()
On error goto errhandler

'your code

Exit sub

errhandler:
'do something here - masgbox etc?
End sub

or perhaps on error resume next?

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[jawbonium]

Thank you for the insight. Sorry about the inaccurate Subject line.

 

[RobBroekhuis]

Y'know, I bet we can figure out why you're getting the error in the first place (but I can't promise anything).


Rob

 

[jawbonium]

Well, I think I may have figured it out. This was the line that was barfing:

Sheets("Summary&quot.Range(Cells(firstEmptyRow, 1), Cells(firstEmptyRow, 11)).Borders(xlInsideHorizontal).Weight = xlThin

I'm GUESSING that the reason this doesn't work is that there isn't technically an INSIDE horizontal line on a single row.

 

[RobBroekhuis]

Methinks you may be right. But then, what is the point of the code line in the first place?


Rob

 

[jawbonium]

Well, I have this nasty habit of cheating when it comes to formatting. I record a macro of what I want done then cut an' paste what I wanted out of it. Sometimes I tailor the generated script down, and in this instance while I trimmed it down, I didn't read it too carefully.