Hi Every one
i have attached file i need serial no automatically while printing. if i print one time it should be come 1 if i print 100 system should be auto generate 1 to 100.
after again if i give print system should print from 101 to how many i have given print.
Thanks
Saliha
Hi Mohamed
There are 2 items in your worksheet.
Are you printing them both at once or one by one?
Are you selecting them if you are printing one by one?
Sunny
Hi Sunny
yes i am printing both in one time.
Hi Mohamed
Give this a try.
Please note that it will always increase the serial number in cell J3 before it prints.
So if you are printing for the 1st time, leave J3 to be blank. Otherwise J3 will be the last number you printed.
I have currently set the option to PrintPreview. Change to PrintOut when you have tested that is is OK.
Hope this helps.
Hi Sunnykow
Thanks yes! this is the one i need
Saliha
Hi Sunny Good Morning
please see the attached file its displaying Error.
Saliha
Please check your macro setting.
i have check and shown to our technical system member also.
Hi Saliha
Right-click on the Print button and select Assign Macro.
Select PrintForm and click OK.
Sunny
Thanks sunny its working now and glad to supporting to me.
Saliha