View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anya[_2_] Anya[_2_] is offline
external usenet poster
 
Posts: 6
Default Object variable error

Hello everyone,

I am having trouble creating a macro that will activate a
GIF picture within a chart and delete it. I keep getting
the following error 'object variable or with block
variable not set error'

Can someone help me with this, I'm going nuts. The macro
is below. Any help would be great.

Thanks

ActiveSheet.ChartObjects("Chart 2052").Activate
ActiveChart.Shapes("Picture 20").Select
Selection.Delete
ActiveWindow.Visible = False