How to set worksheets to print in different order in the same file
 

I want to group pages that are alpha order by dept without doing separate
files.

How to set worksheets to print in different order in the same file
 

Hard to tell when you have used the term "worksheets" in the subject line
and "pages" in the body of your post.

Are those worksheets or printed pages?

You could sort the sheets by name then select the ones the ones to print.

See Chip Pearson's site for code to sort sheets.

http://www.cpearson.com/excel/sortws.aspx


Gord Dibben MS Excel MVP


On Wed, 3 Dec 2008 09:17:01 -0800, Tamall
wrote:

I want to group pages that are alpha order by dept without doing separate
files.