software

I need a cell to display a shaperange name. I'm stumped.--
famdamly
------------------------------------------------------------------------
famdamly's Profile: www.excelforum.com/member.php...oamp;userid=29382
View this thread: www.excelforum.com/showthread...hreadid=515228Try:

Set sr = Worksheets(1).ChartObjects.ShapeRange
Cells(10, 1) = sr.Name

For example a single embedded chart object.
--
Gary's Studentquot;famdamlyquot; wrote:

gt;
gt; I need a cell to display a shaperange name. I'm stumped.
gt;
gt;
gt; --
gt; famdamly
gt; ------------------------------------------------------------------------
gt; famdamly's Profile: www.excelforum.com/member.php...oamp;userid=29382
gt; View this thread: www.excelforum.com/showthread...hreadid=515228
gt;
gt;


I tried working with that, I couldn't get it to work.--
famdamly
------------------------------------------------------------------------
famdamly's Profile: www.excelforum.com/member.php...oamp;userid=29382
View this thread: www.excelforum.com/showthread...hreadid=515228