Posted to microsoft.public.excel.programming

Anya[_2_]

external usenet poster

Posts: 6

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Runtime Error '91' Object variable or With block variable not set	Alec Coliver	Excel Discussion (Misc queries)	2	October 24th 09 02:29 PM
Object Variable Not Set Error on Selection object	Jean	Excel Worksheet Functions	3	July 24th 06 06:45 PM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM
Error trap with object variable problem	Mike H[_7_]	Excel Programming	1	February 6th 04 09:09 AM
Error 91 - Object variable with block variable not set	Jim[_35_]	Excel Programming	2	November 27th 03 03:34 AM

All times are GMT +1. The time now is 12:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us