vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
I'm trying to write some code to move the position of a chart in a worksheet. The problem is that the chart has a strange nubmer assigned to it '24' and this increments everytime I delete it and run a macro to redraw it. Is there anyway to reference the chart generically so that I can modify its location automatically in the same macro, using the incrementleft statement?
I have tried 'activesheet.shapes.select' (or something similar - cannot remember the exact syntax I used) etc. but it didn't work.
Thanks,
vcoder
I'm trying to write some code to move the position of a chart in a worksheet. The problem is that the chart has a strange nubmer assigned to it '24' and this increments everytime I delete it and run a macro to redraw it. Is there anyway to reference the chart generically so that I can modify its location automatically in the same macro, using the incrementleft statement?
I have tried 'activesheet.shapes.select' (or something similar - cannot remember the exact syntax I used) etc. but it didn't work.
Thanks,
vcoder