Comparing String Values
 

Perhaps..

If Value_of_Cell < Title Then Broken = True

--
Jim Rech
Excel MVP
"Ben H" wrote in message
...
| Hi All! I am attempting to add in a bit of code that will check to make
sure
| that the file called and the file that is opened are the same. In other
| words, the title (minus hte .xls) of the file and the cell A1 should have
| the same name.
|
| So far the basic "If Value_of_Cell Is Not Title Then Broken = True"
doesn't
| work
| or this: "If Value_of_Cell = Not Title Then Broken = True"
|
| Title is the name of the file which is being passed it
| Value of Cell is the value of A1.
|
| Under debug mode, the values are the same but the if statement is saying
| "Type mismatch"
|
| Thanks!