Referencing a series of sheets in VB

[bbannock]

I'm trying to create a print all sheets macro in excel. Rather than listing all of this sheets in an array is there any way write a code that will print the range of sheets?

ie. sheets 1 through 20

Thanks for the help.

Brandon

 

[PHV]

And what about this ?
ActiveWorkbook.PrintOut Copies:=1, Collate:=True

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bbannock]

Works like a charm...thank you very much sir