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

On Jul 11, 12:53 am, "Rich" wrote:
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

"Leith Ross" wrote in message
oups.com...
On Jul 11, 12:53 am, "Rich" wrote:
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


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