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 17,324 posts
Seen 7 hours ago
Registered 10 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 18,307 posts
Seen 3 hours ago
Registered 11 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.