software

I am working hard on this simple problem (I think it's not difficult to
implement): insert a row above a certain

cell, for example, the value of the cell is quot;Total Revenuesquot; using
Macro. Does anyone of you know how to do this?

Thanks a lot for your great help!--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: www.excelforum.com/member.php...oamp;userid=26208
View this thread: www.excelforum.com/showthread...hreadid=514583Using the Macro recorder:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2/20/2006 by Jim May

Cells.Find(What:=quot;Total Revenuequot;, After:=ActiveCell, LookIn:=xlFormulas,
_
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.EntireRow.Insert
End Sub
quot;minrufengquot; gt; wrote
in message ...
gt;
gt; I am working hard on this simple problem (I think it's not difficult to
gt; implement): insert a row above a certain
gt;
gt; cell, for example, the value of the cell is quot;Total Revenuesquot; using
gt; Macro. Does anyone of you know how to do this?
gt;
gt; Thanks a lot for your great help!
gt;
gt;
gt; --
gt; minrufeng
gt; ------------------------------------------------------------------------
gt; minrufeng's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26208
gt; View this thread: www.excelforum.com/showthread...hreadid=514583
gt;

Cells.Find(quot;Total Revenuesquot;).EntireRow.Insert--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: www.excelforum.com/member.php...oamp;userid=26208
View this thread: www.excelforum.com/showthread...hreadid=514583