Solved: Graphs to update

[Bob Phillips]

But chart does

[vba]

ActiveSheet.ChartObjects("Chart 1").Chart.Refresh
[/vba]

[asingh]

But chart does

[vba]

ActiveSheet.ChartObjects("Chart 1").Chart.Refresh
[/vba]

I am sure this will work..but is there any way that all the charts on the active sheet get refreshed...without having to hard code in "Chart 1". Or it dynamically loops through all charts found on a sheet.

Else I will create a loop and cycle through each chart........!!!!

thanks,

asingh