| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I insert lines with the help of formulas
Hello,
I wanted to insert one line on the basis of values in the above cells (formula). If formula extracts FALSE then macro should insert one line and do some calculations. Pls advise. Gurdeep |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can I insert lines with the help of formulas
Sub Macro1()
With ActiveCell If .Value = False Then .EntireRow.Insert End If End With End Sub -- Gary''s Student - gsnu200781 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert lines in a cell | Excel Worksheet Functions | |||
| Insert lines at each change in value | Excel Discussion (Misc queries) | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| insert lines | Excel Discussion (Misc queries) | |||
| Macro insert lines | Excel Discussion (Misc queries) | |||
Linear Mode
