Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel XP & Win XP
This one has me stumped. I have a column consisting of various number combinations including: 1-1 1-1M My code is in a For loop running down the column: If i = "1-1" Or i = "1-1M" Then The 1-1 has an apostrophe in front of it to preclude Excel seeing it as a date. I checked the length of each with LEN and they are 3 and 4. The above code cannot find/see the 1-1 or the 1-1M. I even wrote the code as CStr(i)= and had no luck. I am open to any suggestions. Thanks for your time. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |