View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_64_] colofnature[_64_] is offline
external usenet poster
 
Posts: 1
Default Type Mismatch error - tried .text & .value


You'll need to change the second If... to:

If Range("F" & i).Value = "28 Part time" Or _
Range("F" & i).Value = "18 Regular Part" Or _
Range("F" & i).Value = "27 Non-regular Part" And _
Range("M" & i).Value = 20 And Range("N" & i).Value = "" _
Then Selection.Row.Delete


Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=55853