how can I insert lines with the help of formulas

G

Gurdeep Kalra

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
 
G

Gary''s Student

Sub Macro1()
With ActiveCell
If .Value = False Then
.EntireRow.Insert
End If
End With
End Sub
 
Top