Loop through all charts and replace title

Hi everyone!

I have 4 different charts spread across many worksheets. I need help with a code that replaces the chart title in Arabic with its English equivalent. (i.e. if it finds "صافي المبيعات" in the title, replace it with "Net Sales".

I have tried but I cannot manage to loop through all charts on all worksheets.

Thank you for your help!

Peter

This might help ... Not sure abount the replace though

Please Login or Register  to view this content.