Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Problem. The code below just deletes the row as if there are no qualifiers
at all. 'This deletes rows that do not belong in this data extraction. This is a failsafe. For i = 2 To LastRow 'NTNI If Range("F" & i).Text = "1text" And Range("M" & i).Value = 37.5 And Range("N" & i).Value = "" Then _ Selection.EntireRow.Delete 'Parttime If Range("F" & i).Text = "2 text" Or Range("F" & i).Text = _ "3text" Or Range("F" & i).Text = "4text" And _ Range("M" & i).Value = 20 And Range("N" & i).Value = "" Then Selection.EntireRow.Delete 'Fulltime If Range("F" & i).Text < "1text" Or Range("F" & i).Text < "2text" Or _ Range("F" & i).Text < "3text" Or Range("F" & i).Text < _ "4text" And Range("M" & i).Value = 40 And Range("N" & i).Value = "" Then _ Selection.EntireRow.Delete Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 Programming | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |