View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
(PeteCresswell) (PeteCresswell) is offline
external usenet poster
 
Posts: 139
Default Chart or Shape Object: A Place To Stash A Few Bytes?

Per Jon Peltier:
I think PowerPoint shapes have this, but Excel shapes do not. However, you
could add an invisible textbox to a chart:

activechart.Shapes.AddTextbox(msoTextOrientationH orizontal,0,0,100,15).Name
= "MyTag"
activechart.Shapes("MyTag").TextFrame.Characters. Text="$R05$C13:$R45$C22"
activechart.Shapes("MyTag").Visible=false
?activechart.Shapes("MyTag").TextFrame.Characters .Text
$R05$C13:$R45$C22


Thanks. That will definitely do it. I'll hold off on merging the chart
creation/positioning processes and give that a shot.
--
PeteCresswell