auto row insert where TRUE in column A
 

I would like to insert a row only where TRUE appears in column A
Please help.
Thank you

auto row insert where TRUE in column A
 

no help required. thank you though, i figured this one out on my own...
"Mr BT" wrote in message
news:kHjXj.142755$Cj7.33407@pd7urf2no...
I would like to insert a row only where TRUE appears in column A
Please help.
Thank you

auto row insert where TRUE in column A
 

Sub rowtst()

'

Range("a1").Select
Do Until ActiveCell = "" ''change this to meet your criteria
If ActiveCell.Value = "True" Then
Selection.Insert Shift:=xlDown
ActiveCell.Offset(2, 0).Activate
Else: ActiveCell.Offset(1, 0).Activate
End If
Loop

End Sub

"Mr BT" wrote:

I would like to insert a row only where TRUE appears in column A
Please help.
Thank you