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

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