VBA-Excel If Not In String Returning False When Should Be True

Question

I have a simple if statement using the In String function referencing a collection and cell within my worksheet.

    If Not InStr(1, MyPeople(n).DivisionOwner, cel.Offset(0, 12).Value, 1) Then
        cel.EntireRow.Hidden = True
    End If

The problem is that I know for a fact that i am referencing the correct cell and collection cell. I even tested it with a simple MsgBox(MyPeople(n).DivisionOwner)

This means the problem must be in my statement, but it's simply not working!

Public cel As Range, rng As Range is part of my public variables — Coding Novice
– Coding Novice, Commented Jul 24, 2017 at 17:29

Shai Rado · Accepted Answer · 2017-07-24 17:28:07Z

1

Try :

If InStr(1, MyPeople(n).DivisionOwner, cel.Offset(0, 12).Value, 1) = 0 Then

Assuming cel is defined as Range.

answered Jul 24, 2017 at 17:28

Shai Rado

33.7k7 gold badges32 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Coding Novice Over a year ago

yup Public cel As Range, rng As Range. checking

Coding Novice Over a year ago

Just checked. Works fine, just needs 1 instead of zero, thank you!

Shai Rado Over a year ago

@CodingNovice you wanted to check if the Instr doesn't find a match, right ?

Collectives™ on Stack Overflow

VBA-Excel If Not In String Returning False When Should Be True

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related