I'm getting an error in Excel 2003. To see if you get the same do the following:|
1. Create an autoshape in Excel, say an oval.
2. Turn on the macro recorder.
3. Click on the Oval to select it.
4. Stop the macro recorder.
5. Run that code.
I get a run time error and have no idea of how to fix it. Anyone?
Try this in Excel (VBA gurus please)
X201 18,459 posts
Seen 12 minutes ago
Registered 12 years ago
Haven't got Excel at home.
Please call the help desk on Tuesday when normal service will be resumed
Strange, worked for me.
Have a look at the code (Tools->Macro->Macros..., then highlight the one you created and select Edit). It should be similar to this:
ActiveSheet.Shapes("Oval 1" ).Select
Edited by pauleyc at 18:56:28 24-08-2012
Yeah, that's the code, but it doesn't work for me. I get:
Run-time error '-2147024809 (80070057)'
The item with the specified name wasn't found
Stumped. Excel 2003?
Thanks for trying it and posting results btw.
Weird. Did you perhaps rename the autoshape? If you select it, does it say 'Oval 1' in the field left of the formula bar?
neilka 21,205 posts
Seen 4 hours ago
Registered 13 years ago
Have you tried using a circle and making it narrower?
No renaming, the name is fine.
Tried it in Office 2010 and works fine. ARGH.
Sometimes posts may contain links to online retail stores. If you click on one and make a purchase we may receive a small commission. For more information, go here.