Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have following code which is working fine: If Sheets("Sheet4").Cells(rw, 1).Value Like "*TIC*daca". Now I have to modify this line a little bit, but am not able to do it. I want to do two things: 1. The comparison above is case sensitive. I want to make it case insensitive. However I donot want to use Option Compare Text as this case insensitive comparison needs to be valid for this particular code only and not for other comparisons in the module. 2. I want to compare other values too in the same line. Means in addition to "*TIC*daca", I want to compare "FI*pida" with the same cell. Result should be true is cell value is either "*TIC*daca" OR "*FI*pida". How can I achieve this? Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
String Comparison | Excel Programming | |||
String Comparison | Excel Programming | |||
Comparison of alphanumeric string | Excel Discussion (Misc queries) | |||
comparison string VBA excell | Excel Discussion (Misc queries) | |||
String Comparison | Excel Programming |