| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find text then insert new row above
Going round in circles here.... can anyone help please?
I need a macro to do this: Search down column B for some specific text and then insert a new row immediately above the found cell. The new row must copy the formulas and formatting (but not the values) of the row above the found cell. So, find text "last risk above" in column B - let's say this is cell B40. Macro then copies the formatting and formulas of B39 to a new row between B39 and B40. Thanks in advance, Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| Find & Insert - Is this possible?? | Excel Discussion (Misc queries) | |||
| How do I find a value and insert new value | Excel Worksheet Functions | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
![Nick Smith[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
