Thread: Type Mismatch
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Type Mismatch

I receive a 'type mismatch' when trying to use the following line of code to
check the contents of cells and then assign a constant to the variable 'item'.


If Range("n1").Value < "" And Range("n2:n50").Value = "" Then item = 1