Tough one
 

I need a cell to display a shaperange name. I'm stumped.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=515228

Tough one
 

Try:

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

For example a single embedded chart object.
--
Gary's Student


"famdamly" wrote:


I need a cell to display a shaperange name. I'm stumped.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=515228

Tough one
 

I tried working with that, I couldn't get it to work.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=515228