Have you tried DataFilterAutofilter to get the part of the order list then
printing that?


Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 16:05:19 -0700, Chilote perez <Chilote
wrote:

In a worksheet with a orderlist,I would like to print only the part of the
list that I shall order,and not the whole list.How do program the
worksheet/book so that this is possible?