| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a row above a certain cell
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 "Total Revenues" using Macro. Does anyone of you know how to do this? Thanks a lot for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=514583 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert a row above a certain cell
Using the Macro recorder:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/20/2006 by Jim May Cells.Find(What:="Total Revenue", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ActiveCell.EntireRow.Insert End Sub "minrufeng" wrote in message ... 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 "Total Revenues" using Macro. Does anyone of you know how to do this? Thanks a lot for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=514583 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert a row above a certain cell
Cells.Find("Total Revenues").EntireRow.Insert -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=514583 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) | |||
| Update of cell values after insert row? | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
Linear Mode
