Delete whole line with highlighted word

Closed
Cico - Sep 12, 2010 at 04:28 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2010 at 07:43 AM
Hello,

I have a large text and in this text some words are highlighted. I need a mcro to automatically delete each line that contains a highlighted word.

Thanks, by the thousands!

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 12, 2010 at 07:43 AM
in a sample workhsheet highlight some cells and then run this macro


Sub test()
Selection.EntireRow.Delete
Range("A1").Select
End Sub


before using this macro to your original file KEEP A COPY OF THE ORIGINAL FILE SAFELY SOMEWHERE FOR RETRIEVAL.
0