Deleting a row

Posted by LeonMIller on March 14, 2001 2:47 AM

I have in my spreadsheet a row that can be anywhere in it that need deleting, however i cant get the search to delete it as the row is always different, i can get it found by searching via a macro, but i cant get the row passed to a selection. How do i do it.

Posted by Dave Hawley on March 14, 2001 7:14 AM

Leon, try this

Sub TryThis()
Dim Rw As Long
Rw = Selection.Row
Rows(Rw).EntireRow.Delete
End Sub

Dave

OzGrid Business Applications