Delete Rows using R1C1

[bprisk]

I'm trying to delete the rows before to after (inclusive) the currently selected cell in a worksheet. I've searched all over the 'Net and quite locate what I need.

I can't seem to find the right syntax for selecting/deleting the rows as a group.

I'm simply searching for a block of text using Cells.Find(). Then I want to delete that entire row and the one above and below the cell that matches.

Thanks in advance!

Brad

 

[Jonmo1]

Welcome to the board...

Try

Cells.Find(...).Offset(-1,0).Resize(3,1).EntireRow.Delete


Hope that helps.

 

[bprisk]

Awesome!!! Perfect.

Thanks for the quick reply!

 

[Jonmo1]

Glad to help. Thanks for the feedback.