Updating Excel Charts using VBA

[pyth0n]

Hi All

What's the best way to update an Excel Chart using VBA?

At the moment, my script does some work to find the cell where the data is, then edits the Formula for the chart, but after a certain number of iterations this gives me a problem.

Any clues would be greatly received.

 

[GlennUK]

Please post VBA queries in the VBA Visual Basic for Applications (Microsoft) Forum : forum707

You should also include your code when asking this type of question.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[pyth0n]

Sorry, as I thought that this was a general MS Office board, I thought that I would start here. Thanks for the tip.