Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 10-21-2020, 12:07 AM
Guessed's Avatar
Guessed Guessed is offline Select next available mailing label by row and column? Windows 10 Select next available mailing label by row and column? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
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
 

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
Select next available mailing label by row and column? A non mailing label? markg2 Mail Merge 1 12-22-2011 04:07 PM
Select next available mailing label by row and column? Mailing label help needed... Lisa Cotton Word Tables 1 04-14-2011 04:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft