kumaramitouj
10-26-2010, 01:55 AM
Hi,
I am using the following code to delete all rows with "done" data.
what i want is it should delete the same from all sub sheets aswell and insert a row in all sheets including the master, the row thus added should auto copy the fomula from the above row....
is it possible?
Private Sub Remove_Click()
Range("g2").Activate
Do While ActiveCell.Row <= Cells(Rows.Count, 1).End(xlUp).Row
reCheck:
If ActiveCell.Value = "Done" Then
ActiveCell.EntireRow.Delete
GoTo reCheck
End If
ActiveCell.Offset(1, 0).Activate
Loop
End Sub
I am using the following code to delete all rows with "done" data.
what i want is it should delete the same from all sub sheets aswell and insert a row in all sheets including the master, the row thus added should auto copy the fomula from the above row....
is it possible?
Private Sub Remove_Click()
Range("g2").Activate
Do While ActiveCell.Row <= Cells(Rows.Count, 1).End(xlUp).Row
reCheck:
If ActiveCell.Value = "Done" Then
ActiveCell.EntireRow.Delete
GoTo reCheck
End If
ActiveCell.Offset(1, 0).Activate
Loop
End Sub