| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows with #N/A
I am using Excel 97 and want to delete rows of data which have a value of
#N/A in them which is the result from a vlookup formula. I am using the following code but it is debugging with Type mismatch! For i = 2 To LastRow Cells(i, 5).Select If Cells(i, 5).Value = "#N/A" Then ActiveCell.EntireRow.Select Selection.EntireRow.Delete End If Next i Can anyone help with a solution, please? -- Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Threaded Mode
