Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to have this code delete records of parts from a worksheet that do not
match a parts list (in sheet "Elgin Parts"). However, I get the error "invalid or unqualified reference" when I run this code. Why is the code ".Rows(I).Delete" a problem? Any answers? Thanks, GD FinalRowText = Range("A65536").End(xlUp).Row Sheets("Elgin Parts").Select FinalRowElginParts = Range("A65536").End(xlUp).Row Range("A2:A" & FinalRowElginParts).Name = "ElginPartsRange" For I = 2 To FinalRowText Range("A" & I).Select If IsError(Application.Match("B" & I, "ElginPartsRange", 0)) Then .Rows(I).Delete End If Next I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISERROR function | Excel Worksheet Functions | |||
IF ISERROR INDIRECT MATCH Formula Question??? | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
IsError Function | Excel Programming | |||
IF(ISERROR(MATCH - need value where match was found | Excel Programming |