Hi, I am trying to set up a macro for a user: they need to modify multiple chart objects embedded in multiple worksheets. We have several tables of data on each worksheet, with corresponding charts to the right. A new series of data has just been added to each table, and now we need to update the charts. We have constructed a macro that will modify one instance of the chart at a time, but we have to manually change the cell references for each run. I know there's got to be some way to get it to loop through the entire worksheet, but I'm not sure how... BTW - we're using Excel 2003

Following is what we have so far - any suggestions would be appreciated!

Thanks!

Please Login or Register  to view this content.