PDA

View Full Version : delete one row of data



Pete
11-28-2008, 05:46 AM
Hi

Need a macro that will delete one row of data in column A, irrespective of where the the ref is.

So after
RBS_CNY_9510 - 4801delete the row below it

and also delete below one row only
RBS_CNY_9540 - 5436

Bob Phillips
11-28-2008, 05:56 AM
Dim cell As Range

Set cell = Columns(1).Find("RBS_CNY_9510 - 4801")
If Not cell Is Nothing Then

cell.Offset(1, 0).EntireRow.Delete
End If