![]() |
|
#16
|
||||
|
||||
|
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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to select multiple criteria from same column? | LearnerExcel | Excel | 1 | 03-10-2018 07:41 AM |
| move the milestone label to left of column | wilster31 | Project | 0 | 07-31-2017 07:58 AM |
| Error message in pivot when i try drag and placing a column in the row label | olybobo | Excel | 0 | 05-10-2016 02:05 PM |
A non mailing label?
|
markg2 | Mail Merge | 1 | 12-22-2011 04:07 PM |
Mailing label help needed...
|
Lisa Cotton | Word Tables | 1 | 04-14-2011 04:49 PM |