You don't say anything about the layout of your labels. Do you have just
one label on the sheet and it has the numbering you describe, and you want
the number changed every time you print a label? Or do you have 500 labels
on the sheet and you want to insert the numbers before you print the whole
sheet? HTH Otto
"dave" wrote in message
...
I have a spreadsheet to produce labels. I need to be able to number each
label 1 of 500, 2 of 500 etc and then print of the required number of
labels. I am completely stumped.