exporting multiple ranges to a gif gile

[mike53nyc]

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

 

[gimme_this_gimme_that]

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.

 

[gimme_this_gimme_that]

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.