Thread
:
Type Mismatch
View Single Post
#
1
Posted to microsoft.public.excel.programming
Mike
external usenet poster
Posts: 3,101
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
Reply With Quote
Mike
View Public Profile
Find all posts by Mike