Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Office 2003. I have this code
Application.DisplayAlerts = False oWS.Copy after:=oWS Application.DisplayAlerts = True When I step through the first line, and hover over Application.DisplayAlerts, it still shows as TRUE. And when the copy occurs, I get a run time error. The sheet you are copying has more than 255 characters, blah blah blah. I know it does. That's why I do other things later to capture all of the data. Why am I having DisplayAlerts problems here? Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.DisplayAlerts | Excel Programming | |||
Application.DisplayAlerts | Excel Programming | |||
Application.DisplayAlerts in IE | Excel Programming | |||
Application::DisplayAlerts not working | Excel Programming | |||
application.displayalerts | Excel Programming |