By itself, doesn't work because I have Option Explicit. But if I add Dim sn As Variant then the sub works. The second one also works without having to define split with dimSub M_snb()
sn = Split("That is not correct")
MsgBox Application.Match("not", sn, 0)
End Sub




 
			
			 
					
				 
                    
            
            
                 
            
         
					
					
					
						 Reply With Quote
  Reply With Quote