![]() |
|
#7
|
|||
|
|||
|
Hi Bob, I thought the same thing but the only thing I can get the shaperange to return is the count. Even when I declare a variant anything like shpName = activesheet.selection.shaperange.name or shpName = activesheet.selection.shaperange just returns an empty variable. The other issue is that when a shape is programmed to a macro and then ran the shape does not get selected. At least from what I can tell. If someone can figure out what we can return with shaperange we might be able to do it the other way but I don't think it's possible with all the shapes having the same name. Though I could be wrong.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copied shape/text box pastes as an image in Word | spectator | Word | 0 | 06-04-2014 08:45 AM |
how to paste text as shape
|
bsapaka | Excel | 1 | 05-01-2014 06:53 AM |
| Shape+text issue when saving to PDF | HMS | Word | 1 | 07-12-2013 04:43 PM |
autofit text to shape (msoShapeRectangle)
|
viuf | PowerPoint | 2 | 02-20-2012 02:11 PM |
Adding text to auto shape and rotating
|
Hot Mumma | Word | 1 | 06-14-2011 05:15 PM |