I currently have 5 nearly identical subs running at the same time. Each searches the same range of cells for a certain color, and if a cell is that color, it populates sheet2 with the text in that cell. I would like to have just one sub to run all 5 of these at the same time. Is nesting the way to go? If so, any help would be appreciated.
If someone can tell me how to insert the text boxes that contain code so i don't have to copy paste with the actual text, I would appreciate it.
Thanks
I would use the select case format, with a different case for each color. You can find information about it here:
http://www.techonthenet.com/excel/formulas/case.php
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks