| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1)
Can someone please tell me what is wrong with this line of code, the return
value is constant at zero even when the value of c is within Sheets("TEG").Cells(i, 18) i.e. c = NYNYNJ3440 and, Sheets("TEG").Cells(i, 18) = W-440 NYNYNJ3440- Midland Park DPW Thank you. Ayo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets("Sheet1").Cells.ClearContents | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Do indiv. sheets (or cells) have "TextToColumns" properties? | Excel Programming | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Threaded Mode
