redu code for additional instring debugging
Posted on 2012-08-28
excel 2010 vba
If InStr(1, Target.Address, str) > 0 And Target.Value <> "" Then
'we are in the entry column
If getdata(Target) <> "" Then
str = <is usually a value of an Alpha character>
if the str is instring in the target.address then routine gets ran
so if the address is $I$52
and the "str = I" THEN the routine gets ran.
sometimes the target.address is a double Alpha like AI52....IN THIS CASE I DO NOT WANT THE ROUTINE TO RUN SO END THE IF STATEMENT
BUT THE CODE IS FINDING THE "I" inside the target address
I need to get around this double alpha problem.