Setting the print area?

Thanks a lot for the FAST reply!


I've already discovered the code you mentioned using APIMate, but it didn't seem to work in thie first place. Now with your reply I found the issue: I'm setting the print area after a sheet has been generated for each sheet. It seems however, that it's overwriting the setting so only the last sheet is configured with the proper print settings.

Looking at this example however, Excel seems to know this setting per page:
http://excel.tips.net/T003157_Setting_Print_Ranges_for_Multiple_Worksheets.html

Any way to get this working using Flexcel?

Thanks and regards,

  Patrick