You would probably need some kind of selection event
(Worksheet_SelectionChange) to reset the print area to your currently
selected range.

I know you might not want to hear this, but why not use MS Word to
print labels? It's already designed to handle your needs. You can even
set up a macro so that someone can enter the label information in a
spreadsheet, save and close, then open the Word doc and press a button
to print the label.


HTH,
JP

On Apr 8, 8:31*am, "Arvi Laanemets" wrote:
Hi

I'm designing an Excel application for printing shipping labels. The user
enters shipment data into a table (a row for every package), selects the
shipment, and on report page predesigned A5 format labels are filled with
data (texts, numbers, and barcodes)

As the number of packages in shipment varies, I have to find a way to avoid
empty labels to be printed. I have designed a dynamic named range, which
returns exactly the wanted range.

When on Sheet tab of Page Setup page I enter into Print area field the
formula '=MyRange', the Excel recognisez it and only filled labels are
printed. But when I open the Page Setup again, the named renge is replaced
with absolute range reference. And when I now select another shipment, the
wrong number of labels is printed.

Can someone help me with this? Thanks in advance

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )