change order of graphs when using macro to export all excel charts to powerpoint

Hi all,

I've been using a VBA code to look through my spreadsheet and find any graphs in any tab and move it to powerpoint. I have about 70 tabs with 7 graphs each.
Issue I have is that the order of the graphs in the slidepack isn't in the same as found on each excel tab.
I also tried renaming them (chart1-chart7) but problem still remains.
Has anybody have any suggestions? Really appreciate any help. Thanks

Originally Posted by mrice

I guess that you are hoping for charts to be read left to right and then top to bottom. If so, you can get the cell number like this

Please Login or Register  to view this content.

Sorting by this would then give you the desired order.

Hi Martin,
Thank you for your quick response! Much appreciated! However my VBA knowledge is limited and I am having trouble to integrate your solution in my code.
I attached the code below. If you could suggest where exactly to put your statement would be great. Thanks

Please Login or Register  to view this content.

Thanks again

Originally Posted by mrice

I guess that you are hoping for charts to be read left to right and then top to bottom. If so, you can get the cell number like this

Please Login or Register  to view this content.

Sorting by this would then give you the desired order.

Hi Martin,
Thank you for your quick response! Much appreciated! However my VBA knowledge is limited and I am having trouble to integrate your solution in my code.
I attached the code below. If you could suggest where exactly to put your statement would be great. Thanks

Please Login or Register  to view this content.

Thanks again