Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete entire line base on a returned value
I've read a number of posts to remove a line based on a no value being returned but can't find out how to remove based on a specific value being returned.
e.g. I have a merge line below where 'UK Equity' is text UK Equity { =100* { MERGEFIELD BenchUK2 } \# "0.0%" } Currently, if the value returned is 0.0% the merge shows 'UK Equity 0.0%' However, if the value returned is 0.0% I wish to delete the whole line including the text 'UK Equity' and don't want to see a blank line. I realise I need an IF statement but I can't find the instruction to delete the line. I think I need something like this: UK Equity { IF { =100* { MERGEFIELD BenchUK2 } \# "0.0%" } = 0.0% { 'delete the entire line including the text UK Equity'} NB. I think I may need an instruction like shift + home + delete, but don't know anything about VBA and how to apply it to the field codes. Thanks if you can help Mike |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't mail merge use the entire data base? | Mailmerge | |||
Macro to find text, then delete entire line containing the text? | Microsoft Word Help | |||
word tables delete default should be delete entire row not shift | Tables | |||
My delete key deletes entire words...cannot delete letters | Page Layout | |||
How do I delete an entire line in Word? | Microsoft Word Help |