Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Norman meant that the dictum is to always explicitly state the method of
comparison within the instr function command rather than depend on any default/global setting. He used the term text comparision to mean how the comparison is to be performed (binary or text) rather than that the vbTextCompare be used as you appeared to interpret his suggestion. Futher he envisioned this as a guiding principle in general across all functions where appropriate - an Axiom An admirably clear exposition of my intent! Whoops!!! Sorry, I completely missed what you were saying. Yes, explicitly specifying values instead of relying on defaults would be a good practice to get into... and for object properties I always do that; but I am a long time BASIC and VB user (started programming in BASIC back in 1981), so some "bad" habits have become totally ingrained over the years. Relying on the default start position of 1 and the default text comparison method of "case sensitive" for the InStr function is one of those bad habits... after nearly 30 years of not specifying them, I probably will never remember to do so in the "heat" of a programming session. Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find specific info using search string using VBA | Excel Discussion (Misc queries) | |||
Easiest way to find differences between Rows? | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
search a string withing a string : find / search hangs | Excel Programming |