View Single Post
 
Old 10-21-2020, 12:07 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Mike

Firstly, get rid of the shapes on the Outer envelope worksheet. They don't add any value and:
- they make the coding harder
- they won't ever align perfectly with the labels coming through the printer so they will look bad

Are you trying to add a new label row to that sheet each time the 'Create new' button is pressed? As in, the first time we fill in row 1, then row 2, then 3 etc until we hit the maximum of 7. If so, why do you expect the user to work out the next available slot (row/col). The macro should be able to work this out by iterating through the cells until it hits an empty one.

What is the point of the labels? Are you trying to be environmentally conscious and feed the same sheet through the printer each time a label is required until all the slots are used? If so, you will need to wipe the 'already gone' slots because the toner won't stick to the exposed backing and it will kill your printer pretty quickly.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote