Enter1
New Member
- Joined
- Sep 3, 2014
- Messages
- 8
Hello All,
Im currently working on a project where I have excel files that have atleast 60-100 graphs each for different parameters. I wanted to list the underlying cell location of these charts in a separate excel sheet. I know I can do the opposite using VBA (specify where a chart can be placed at a desired range in a sheet).
For example I have a graph - chartobject above a range - E3:I13 , I would like to know if we can use VBA to get that underlying range address.
Unable to find a fix to this
, if one of you can help then that would be of great help
.
Thanks.
Im currently working on a project where I have excel files that have atleast 60-100 graphs each for different parameters. I wanted to list the underlying cell location of these charts in a separate excel sheet. I know I can do the opposite using VBA (specify where a chart can be placed at a desired range in a sheet).
For example I have a graph - chartobject above a range - E3:I13 , I would like to know if we can use VBA to get that underlying range address.
Unable to find a fix to this


Thanks.