I have a whole bunch of charts in a workbook and would like to change their numbers around if it's possible. By number I mean this: if you were going to start recording a macro and just clicked on a chart, excel macro recorder will record this action for example:
Is there a way to change that 139 number to a number I choose?
Please Login or Register to view this content.
Thanks
Last edited by luv2glyd; 01-14-2014 at 06:42 PM.
You either quit or become really good at it. There are no other choices.
Use this as a starting point and adopt to your needs"
Please Login or Register to view this content.
Hi luv2,
See the attached routines. I hope they help you.
Lewis
Change Shape Name. Substitute your names in the quoted text.
Identify Shapes. The following identifies all the Shapes in the Active Worksheet. Results are displayed in the 'Immediate Window' (CTRL G).Please Login or Register to view this content.
Please Login or Register to view this content.
Great! Thank you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks