VBA Instr function on ItemHTMLText ?

Submitted by viking on 2025/09/22 01:13

I have a table which has ItemHTMLText  
ABCDEF  || GHIJKL || ......

I use Instr(ItemHTMLText, "ABC") , which returns 1 as expected
However, Instr(ItemHTMLText, "GHI") returns 0. In other words, it is not found...

Maybe it is not possible to search ItemHTMLText, and I must search ItemHTML instead?
 

Comments

Sorry, my bad! There was an error in the VBA code (I just realized that some words are reserved). All good!
BTW, is it possible to search for the "||"; what character(s) should I use? "||" didn't work

How do I ?