View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default ClearArrows - Runtime Error 1004

Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes
no error.
Maybe the problem is with the WS reference.

NickHK

"moonhk" wrote in message
ps.com...
How to check worksheet contents of Arrow? if yes, the start to clear
Arrows (Auditing Arrows) ?

loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case
runtime error 1004.