View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Application.DisplayAlerts problem

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