Increment serial number for each printed page

[hbasbay]

Hello eveyone,

first sorry about my english.I have a excel file to print label on a label printer.I've added additional file in this message.I'm printing different numbers of labels with this file.for example, if I print 10 pieces of labels, I want to write 1/10 , 2/10 , 3/10 etc. on each label.I finded a vb code to print this work but not exactly the way I want.I would ask one of excel guru's to look at my file.

thank you very much for your help.

best ragards

Huseyin Basbay

[G e r a r d]

This may do the job:

Please Login or Register  to view this content.

[jmac1947]

Hello Huseyin and welcome to the forums,

I looked at your attachments and unfortunately, as I dont speak or read "turkish" it doesnt make much sense to me

We would love to help but perhaps you need to do the translations in your sample for us please

We are all volunteers who are commited to spreading the use of VBA in Excel to solve real business (well any real ) problems so and we love to help people who are in genuine need

[HaHoBe]

Hi, Huseyin Basbay ,

maybe use it like this (I used PrintPreview instead of PrintOut):

Please Login or Register  to view this content.

Ciao,
Holger

[hbasbay]

dear HaHoBe,

thank you very much for your interest.the code that you create for me is working.but every time print PrintPreview screen is showing on the screen.is it possible to send all labels on each time? PrintPreview screen is taking time on each print.

best regards

Huseyin Basbay

PS: I would like to thanks to G e r a r d and jmac1947 for their interest.

[hbasbay]

dear HaHoBe,

thank you very much for your interest.the code that you create for me is working.but every time print PrintPreview screen is showing on the screen.is it possible to send all labels on each time? PrintPreview screen is taking time on each print.

best regards

Huseyin Basbay

PS: I would like to thanks to G e r a r d and jmac1947 for their interest.

[HaHoBe]

Hi, hbasbay,

why not replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Ciao,
Holger

[hbasbay]

Dear HaHoBe,

Thank you very much again.It really works.you are amazing.

Best Regards

Huseyin Basbay

[jmac1947]

Hi, hbasbay,

happy to see your issue has been fixed.

@HaHoBe is one clever person, he has also helped me before today.

If you are happy that the question has been resolved then please use the "Thread tools" at the top of your first post to mark the thread as "Solved"

If you are happy with the help from @ HaHoBe then at the bottom of any one of his posts please click the "*Add Reputation" *** a way of saying thanks to Holger

Happy to see that your first visit has ended well. Please remember however that we are all volunteers who like to assist in solving a problem, we do get a bit grumpy sometimes if we feel that the OP (Original Poster) has not tried to find a solution themselves before turning to the forum. There is a good search option in the forum itself and of course Google has a huge range of potential answers on "How to...."

Cheers

Jmac1947