software

I have the same issue as in this post (with a different word) from 2005:

****I need to find the word quot;Highquot; in a whole speedsheet, and remove the
whole
row containg that word.
Thanks****

This was the response:

Sub FindCellDeleteRow()
'
Cells.Find(What:=quot;highquot;).Activate
ActiveCell.Rows(quot;1:1quot;).EntireRow.Select
Selection.Delete Shift:=xlUp
End Sub

My question is how do I apply the solution? Where does this does this code
go? Any info would be greatly appreciated.
My question is how do I apply the solution? Where does this does this code
go? Any info would be greatly appreciated.[/QUOTE Wrote:
gt;
gt;
gt; Hi there,
gt; when you are in your workbook, press Alt amp; F11
gt; You will then be in VB
gt; at the top menu select insert, module
gt; copy and paste your code in there
gt; when you want to run your macro, press Altamp; F8
gt; your macro will show up and then select it and click run
gt;
gt;
gt; Or you can create a button and assign your macro to it--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=521949Thanks so much!

quot;davesexcelquot; wrote:

gt;
gt; My question is how do I apply the solution? Where does this does this code
gt; go? Any info would be greatly appreciated.[/QUOTE Wrote:
gt; gt;
gt; gt;
gt; gt; Hi there,
gt; gt; when you are in your workbook, press Alt amp; F11
gt; gt; You will then be in VB
gt; gt; at the top menu select insert, module
gt; gt; copy and paste your code in there
gt; gt; when you want to run your macro, press Altamp; F8
gt; gt; your macro will show up and then select it and click run
gt; gt;
gt; gt;
gt; gt; Or you can create a button and assign your macro to it
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=521949
gt;
gt;