LinkBack URL
About LinkBacks
There must be a cleaner way to right this code, it works but I know it's not right.
Please Login or Register to view this content.
There must be a cleaner way to right this code, it works but I know it's not right.
Please Login or Register to view this content.
My advice: Leave it alone.
Ben Van Johnson
Hello zplugger,
Here is an example that applies to all labels on the ActiveSheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I must be doing something wrong Leith, can't get the code to work
Z
Hello Z,
The code needs to be in a standard VBA module. The macro now checks "Sheet1" for the Labels and cell F5 is not empty. Change "Sheet1" to the name of your worksheet that has the labels.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks