Print Selection without changing position on paper

**dansditties** · 06-21-2007, 03:16 PM

I used excel to print labels on an avery label sheet. Each label on the sheet has a range of cells printed on it. I would like to make a macro to print a single label from that sheet without changing the location on the sheet of paper.

I have tried this myself. But the selection is always printed at the top of the page.

Any ideas on how to solve this dilema?

**avveerkar** · 06-22-2007, 02:45 AM

Originally Posted by dansditties

I used excel to print labels on an avery label sheet. Each label on the sheet has a range of cells printed on it. I would like to make a macro to print a single label from that sheet without changing the location on the sheet of paper.

I have tried this myself. But the selection is always printed at the top of the page.

Any ideas on how to solve this dilema?

You need to elaborate more. As I understand that you have, for each label to be printed, one row on the excel sheet and you pick up data from various columns of this row to print the label. Basically one row per label.

Physicall do you have multiple labels on a sheet of paper? And you want printing to shift from one label to next label after completing the first label? And your problem is that instead of printing on the next label on the sheet it prints on the same label?

A V Veerkar

**dansditties** · 06-22-2007, 08:05 AM

I have attached what the sheet looks like. There are several labels on the sheet. On the attached document, you'll see that each pair will print on an individual label.

Here's the situation. Sometimes I don't need a whole sheet of these labels. I would like to print one pair of labels, then say on a later date, I would like print a couple more pairs and so on until I have used all the labels on the sheet.

The problem is that when I select a pair of labels and press print selection, the selection is printed at the top of the page where the margin starts. I would like to figure out how to leave it in it original position on the page.

The label paper comes in standard "8.5 X 11" size paper.