Macro error I cant solve

[Rich]

I have a macro the keeps falling over at the line:-

ActiveSheet.Shapes("Object 1").Select

The error message is:-

Run-time error '-214724809 (80070057)':
The item with the specified name wasn't found.

Any ideas ?

--
Rich

http://www.richdavies.com

http://www.richdavies.com/fishkeeping.htm

 

[Leith Ross]

I have a macro the keeps falling over at the line:-

ActiveSheet.Shapes("Object 1").Select

The error message is:-

Run-time error '-214724809 (80070057)':
The item with the specified name wasn't found.

Any ideas ?

--
Rich

http://www.richdavies.com

http://www.richdavies.com/fishkeeping.htm

Hello Rich,

Did you rename your shape to "Object 1"? Most shape objects have
descriptive names like
"Square 1", "Circle 5", etc. To check the name, click on the shape and
look at the name drop down box next to the Formula Bar.

Sincerely,
Leith Ross

 

[Rich]

Hello Rich,

Did you rename your shape to "Object 1"? Most shape objects have
descriptive names like
"Square 1", "Circle 5", etc. To check the name, click on the shape and
look at the name drop down box next to the Formula Bar.

Sincerely,
Leith Ross

Thanks Leith,

Now I understand this relates to the excel shape name, the shape function
wasn't really need so I've deleted the lines that go with it and all is
fine.

Rich