| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining A Cell If it contain A string value
I've always have trouble with this one could someone help?
I can determine if a cell has a numeric value but not a string value. Sometimes I can get it to work but for some reason it's not very reliable? As a result need a more definate code. I have attached the macro, it is range 02 that is giving me grieve If Range(range01) 0 And Range(range02) < 0 Then It was as below which worked sometimes works If Range("B1") = "" And Range("C1") < "" Then |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining AM or PM in text string | Excel Worksheet Functions | |||
| Determining text in a cell | Excel Programming | |||
| Determining active conditional format of one cell | Excel Programming | |||
| Determining Cell Types in Excel - exceptions | Excel Programming | |||
| Determining whether selected cell has value or formula? | Excel Programming | |||
Threaded Mode
