MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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