Thread: Run-time error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ljCharlie[_11_] ljCharlie[_11_] is offline
external usenet poster
 
Posts: 1
Default Run-time error

Here's the code:

If U.Cells(i).Value = "Yes" Then
Selection.Rows(i).EntireRow.Delete
End If

I'm trying to compare the cell value in column U to see if it equals
the word "Yes" and if it is, delete the whole entire row. The error was
Run-time error 424 Object require at the above code.

Any suggestion is apreciated.

ljCharlie


---
Message posted from http://www.ExcelForum.com/