Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Sometimes the help file is wrong and sometimes things just don't work. I just remember (quite awhile back) going thru a lot of trials with group shapes before I found something that worked. I then saved the code for future reference. Also, I recall that the array used to create the ShapeRange must be a variant data type or things fail. Jim Cone Portland, Oregon "LurkingMan" wrote in message Thanks Jim. Ungrouping and regrouping lets it all work. I saw this in the VB help and was led to believe I could work with objects without ungrouping them. GroupShapes Collection Object Represents the individual shapes within a grouped shape. Each shape is represented by a Shape object. Using the Item method with this object, you can work with single shapes within a group without having to ungroup them. Hmm, there's also the point that I could get .Name from the shape without ungrouping. Do you happen to know why one member function works and another doesn't? -- In theory, there is no difference between theory and practice. In practice, there is no similarity. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Center text in a shape textframe | Excel Programming | |||
use VBA to tell if all the text in a TextBox or TextFrame can be displayed | Excel Programming | |||
TextFrame.Characters.Text returns truncated string | Excel Programming | |||
cell to textframe using characters object | Excel Programming | |||
.TextFrame.Characters.Text property readOnly in function?? | Excel Programming |