Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nightofthehawk Nightofthehawk is offline
Junior Member
 
Posts: 1
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why won't mail merge use the entire data base? Aerial34 Mailmerge 1 November 1st 09 09:59 PM
Macro to find text, then delete entire line containing the text? Tailings Microsoft Word Help 2 September 16th 06 03:52 AM
word tables delete default should be delete entire row not shift littleleaves Tables 1 August 15th 06 05:39 AM
My delete key deletes entire words...cannot delete letters secaneta Page Layout 1 July 25th 06 05:51 PM
How do I delete an entire line in Word? J.R. Aiello Microsoft Word Help 1 January 11th 06 10:40 PM


All times are GMT +1. The time now is 03:32 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"