LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default exporting multiple ranges to a gif gile

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming Ranges for data exporting blondage Excel Discussion (Misc queries) 1 March 28th 07 07:08 AM
Exporting Access Queries to sepcific ranges in an Excel workbook MWACardsfan Excel Programming 3 October 19th 05 09:01 AM
Exporting to CSV or Text files with variable ranges on a worksheet Neale[_2_] Excel Programming 0 July 8th 05 02:30 PM
Exporting to CSV or Text files with variable ranges on a worksheet Neale[_2_] Excel Programming 0 July 8th 05 02:29 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"