Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Ranges for data exporting | Excel Discussion (Misc queries) | |||
Exporting Access Queries to sepcific ranges in an Excel workbook | Excel Programming | |||
Exporting to CSV or Text files with variable ranges on a worksheet | Excel Programming | |||
Exporting to CSV or Text files with variable ranges on a worksheet | Excel Programming |