Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing the first 2 characters of a coloumn to a string | Excel Worksheet Functions | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Comparing values | Excel Discussion (Misc queries) | |||
Question about comparing mixed case string values | Excel Programming |