In your if statement try putting .value at the end before the 1,i
and in the other range also.

If Mid$(LicenseRangeA.Cells(k, 1).*value*, 1, i) =
Mid$(LicenseRangeB.Cells(j, 1).*value*, 1, i) Then........

Not sure it will work, but no harm in trying.


--
securityman
------------------------------------------------------------------------
securityman's Profile: http://www.excelforum.com/member.php...fo&userid=8829
View this thread: http://www.excelforum.com/showthread...hreadid=485763