I was greatful to find Harold Staff's code on David MacRitchie's site
for extracting a range to a gif file. I am new at VB and I would like
to be able to run the macro to export 2 ranges from each of 10 sheets
to gif files (20). I have created defined names. But I am unable to
figure out the code that is used within the loop.

The sheets are named 1r1 thru 10r1 and the ranges within each sheet are
A1:F25 and A26:F50. The defined names are structured as follows: For
sheet 1r1 the two defined names are ex1r1a for A1:F25 and ex1r1b for
A26:F50.

Any hints or help would be appreciated.

Thanks
Mike

I'm at home - so I'm using the Mac version of Excel.

Turn on the recorder.

Select a range.

Press the shift key (keep it pressed)

Edit-Copy Picture

Paste the image into a blank sheet.

Do the same thing pasting the 2nd selection to the same blank sheet.

Do the same thing to the sheet that has both images.

Stop recorder. Modify.

Oh yeah... Thought I'd pass along another tip.

After pasting the final image to the worksheet you can save the
workbook in HTML format, go into explorer, survey the *_files
directory, and from there find the gif image you created.