I have several charts on sheet1. Every chart lies between columns A and
AE starting from the top of the sheet to downward. Each chart's source
data start in the first row below the chart and the source data (i.e
setsourcedata) is about 2,3,or 4 rows long(it varies from chart to
chart). Each chart's source data is updated from column A to column AD
only.
- I need a macro that will loop through each chart, click on it, and
update the source data (i.e setsourcedata) to from column A to AE
instead.
I will appreciate any help.
~Flex
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!