#1
|
|||
|
|||
Remove Red macro
Hello,
I have a macro where it will remove all colors that are Red and any data of it and will not include the next different color and their data. The problem lately I'm noticing that the macro is also removing the next color after Red and some of its data. Can you please check what I've missed on this? Here is the print screen (I don't know how to upload the word file here) --> http://s14.postimage.org/olbv9g3up/Test.jpg . The ones in yellow shades should be removed but it should not include the next color (ex: Blue and its data) but for some reason the macro below is also removing them Code:
Last edited by macropod; 03-14-2013 at 10:46 PM. Reason: Added code tags & formatting |
#2
|
||||
|
||||
As explained in the thread you got the code from:
https://www.msofficeforums.com/word-...fic-words.html Quote:
Instead of getting reports that don't really meet you needs and require considerable massaging afterwards, I really do think you should be looking at getting some new reports that actually reflect your requirements.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
hi macropod,
I'm glad it's an easy fix. Thanks again! Netchie |
#4
|
|||
|
|||
Hi macropod,
If I make it 30, it's possible that some of data below Red won't be removed. Sometimes Red has 3 rows below and sometimes 2. If let's say the number I changed can remove 3 columns below RED and the report has only 2 columns for RED then it will automatically removed the third column which is BLUE. How can I add the if and then where if it's RED and it has "1" or "2" or "3" below it then they need to be removed? |
#5
|
||||
|
||||
It really isn't practical to try to test what's in other frames nearby, especially when there could be more than one of them. There is a limit to what can be achieved in this situation and you're already pushing that limit.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
I see; well it worked so far so thank you again for checking this for me and I hope you won't sick and tired of checking my Word issues.
Have a great day! Thanks, Netchie |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to remove blank column | netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
Need VBA For Macro On How To Remove Specific Words | netchie | Word VBA | 6 | 08-28-2012 03:37 PM |
Macro to remove MacroButtons | ilkks | Word VBA | 3 | 05-22-2011 11:03 PM |
Need help on Macro 03- Find text - if text is blank then remove line | simpleonline1234 | Word VBA | 1 | 02-25-2011 02:28 AM |
Macro to remove duplicates in Refrences list | HowardC | Word VBA | 0 | 05-20-2010 09:57 AM |