![]() |
#1
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
![]() |
netchie | Word VBA | 6 | 08-28-2012 03:37 PM |
![]() |
ilkks | Word VBA | 3 | 05-22-2011 11:03 PM |
![]() |
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 |