Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |