Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch error - tried .text & .value
*Sigh*
Ok. I keep getting a type mismatch error on the second if statment. 'This deletes rows that do not belong in this data extraction. This is a failsafe. For i = 2 To LastRow If Range("F" & i).Value = "98 Other Country" And Range("M" & i).Value = 37.5 And Range("N" & i).Value = "" Then Selection.Row.Delete If Range("F" & i).Value = "28 Part time" Or "18 Regular Part" Or "27 Non-regular Part" And Range("M" & i).Value = 20 And Range("N" & i).Value = "" Then Selection.Row.Delete If Range("F" & i).Value < "98 Other Country" Or ""28 Part time" Or "18 Regular Part" Or "27 Non-regular Part" And Range("M" & i).Value = 40 And Range("N" & i).Value = "" Then Selection.Row.Delete Next i I have tried using both .value and .text with no luck. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type Mismatch error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Type Mismatch Error | Excel Programming |