#1   Report Post  
Posted to microsoft.public.excel.misc
famdamly
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
famdamly
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tough question SHAETY Excel Discussion (Misc queries) 8 February 17th 06 04:32 AM
Tough Concatenate Problem BCBC Excel Worksheet Functions 3 February 16th 06 10:13 AM
Multiple Variables in a Commission Structure...a tough one!!! Oriana G Excel Worksheet Functions 9 January 21st 06 07:52 PM
help me on tough sum on conditions issue amrezzat Excel Worksheet Functions 4 November 15th 05 10:06 AM
Tough problem with rotas Scott Cheesman Excel Discussion (Misc queries) 0 April 2nd 05 10:51 AM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"