| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
If resulting in False when it is actually true
It does return a range object, but the default propety of a range object is
value, so this suggestion would not affect the results in this situation as you have discovered. -- just for clarification. -- Regards, Tom Ogilvy "Papa Jonah" wrote in message ... OJ, I have tried adding .value. That did not work either. This section of code was modeled after another section that does work. The only difference is I don't think it involved numbers, but text. "OJ" wrote: Hi Jonah, try ... If item = Cells(u + 1, "aa").Value I think Cells(u+1,"aa") returns a range object..From Help... Using this property without an object qualifier returns a Range object that represents all the cells on the active worksheet. Hth, OJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| True Or False, no matter what... it still displays the false statement | Excel Programming | |||
Threaded Mode
