litestream
Active Member
- Joined
- Jul 24, 2006
- Messages
- 323
I have 2 worksheets - called "Data" and "Labels"
The "Label" worksheet is in fact a label which is affixed to a pallet for delivery. Each label says "pallet x of y" where "y" is the total number of pallets and "x" is the number of the pallet.
"x" is a fixed number which I enter into cell A1 of the "Data" worksheet (usually 1 unless I have to stop the printing and resume at a later time)
"y" is the total number of pallets for the delivery and is taken from cell B1 of the "Data" worksheet but is the result of a formula which works out the number of items on each pallet.
On the "Label" worksheet, cell C1 is the pallet number and C3 is the total number of pallets
How can I print out consecutive numbered labels? I know it's part of a "for next loop" but I'm unsure how to do this in VBA.
Any assistance would be greatly appreciated.
The "Label" worksheet is in fact a label which is affixed to a pallet for delivery. Each label says "pallet x of y" where "y" is the total number of pallets and "x" is the number of the pallet.
"x" is a fixed number which I enter into cell A1 of the "Data" worksheet (usually 1 unless I have to stop the printing and resume at a later time)
"y" is the total number of pallets for the delivery and is taken from cell B1 of the "Data" worksheet but is the result of a formula which works out the number of items on each pallet.
On the "Label" worksheet, cell C1 is the pallet number and C3 is the total number of pallets
How can I print out consecutive numbered labels? I know it's part of a "for next loop" but I'm unsure how to do this in VBA.
Any assistance would be greatly appreciated.