Hi

I have a macro which generates multiple sheets containing a single chart. The sheet and chart are automatically named. I then have to copy each of these charts into power point (manually) by 'copy', move to power point, 'paste special', 'as .emf'(last time 140 charts). What I would prefer is, this marco which generates the charts then saves them outwith excel as emfs using the chart name as the file name.