VBA Code to select charts based on VBA code

Hi All,

I would like to manipulate the Peltier VBA 'Excel to Powerpoint' code (find below) to copy across multiple charts automatically (without having to select them individually by hand). The charts I need to copy across are based on an IF statement which shows if the category is spending more than the average and then display an "X" next to the row.

I have tried the original Peltier code and it works brilliantly but I just need help with the selection code. Is this possible?

Thanks in advance.

Will

Please Login or Register  to view this content.