macro to copy and paste data to new sheet

mypassion1,

You have changed the workbook, and the example I have supplied works for your original workbook, because it looks for the word "Max".

The problem is, you can't just export a range in a worksheet as a .Gif. without additional help.
Andy Pope's Addin works well, Dave McRichie's code works as well (links supplied in previous post), to selecting a range and saving that range as a .Gif, but I could not automate it to work in a worksheet loop.

You can though, export a chart as a .Gif, and that is what I have been working on. The example supplied, copies each worksheet range as a .Gif and places it into a chart, the chart is then exported as a .Gif to the folder I originally mentioned in the previous post. Andy's revised code makes sure that the "Worksheet" picture fits in the chart, so that there is no missing information outside of the chart before it gets exported.

Why the .Gif's come out as blank is probable a windows issue, you should exit Excel and then open the workbook, sometimes if you open a workbook with the same name as a previous open workbook, the previous version is what is opened, especially if you are downloading it from the internet.

Thanks Andy for the revised code.