Prev: office 2007 and vsto
Next: Error Trying to add Calculated Items to a pivot table
From: Rich on 11 Jul 2007 03:53
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


From: Leith Ross on 11 Jul 2007 04:08
On Jul 11, 12:53 am, "Rich" <n...(a)amnospam.net> 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

From: Rich on 11 Jul 2007 04:45

"Leith Ross" <LeithRoss(a)gmail.com> wrote in message
news:1184141291.406473.224240(a)m37g2000prh.googlegroups.com...
> On Jul 11, 12:53 am, "Rich" <n...(a)amnospam.net> 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


 | 
Pages: 1
Prev: office 2007 and vsto
Next: Error Trying to add Calculated Items to a pivot table