Can anyone please help me understand where I am wrong as I am getting “0” returned everytime?
whichone = “WordingPreliminary”
returnval = Instr(“pre”, Lcase(whichone))
and returnval is always “0”. Shouldn’t it be “8”?
Can anyone please help me understand where I am wrong as I am getting “0” returned everytime?
whichone = “WordingPreliminary”
returnval = Instr(“pre”, Lcase(whichone))
and returnval is always “0”. Shouldn’t it be “8”?
Subject: Instr issue, where am I wrong?
your syntax is wrong, should be
whichone = “WordingPreliminary”
returnval = Instr(Lcase(whichone),“pre”)
Subject: RE: Instr issue, where am I wrong?
Rampisad,Thank you! I knew it was something small I was missing.