Printing non-adjacent areas on seperate sheets in one print job
 

I've got a business modelling workbook that contains abt 25 worksheets, each with a large number (40) of "tables" on any single worksheet. What I've doen so far is automate (via VBA) the printing of "reports" where non-adjacent named ranges are created and then selected and printed. This gives me a single print job for each worksheet, with each table on it's own page.

However, the named ranges are giving me grief because of it 255 character limitation for the RefersTo property. I've done some playing with the Union function to group named ranges together temporaily for printing purposes, but have not been too successful.

Does anyone know of a easier or more efficient way of accomplishing what I'm trying to do. I'm thinking something possibly with the Areas property, etc.

Thanks

Dan Knight