Why do I get an object error 91 on this usage of code?

[vbaNumpty]

 Set findValue = imageB.Range("X:X").Find(what:=myarray(j, 1), _
            LookIn:=xlValues, lookat:=xlWhole)
        'Using to match values to original launched data
        Set searchValue = dashB.Range("X:X").Find(what:=myarray(j, 1), _
            LookIn:=xlValues, lookat:=xlWhole)
            
            'if the order is new addition
            If searchValue = "" Then

the line:

If searchValue = "" Then

returns the 91 error.

How can I make it so that my If portion does its thing if the searchValue variable returns nothing (i.e doesn't exist in the search range of the find function)?

I have tried making the if searchvalue = Nothing then, but it didn't like that either.

 

[vbaNumpty]

if searchValue is Nothing Then

 

[jasonb75]

You need to use Is instead of =

If searchvalue Is Nothing Then

Although it is more common to use

If Not searchvalue Is Nothing Then

In order to test if something was found rather than testing to see if it wasn't found.

 

[Fluff]

It should be

If searchValue Is Nothing Then

 

[jasonb75]

Thanks Jason!

This thread is going to confuse anyone who didn't see your post before you edited it ?

 

[vbaNumpty]

This thread is going to confuse anyone who didn't see your post before you edited it ?

I found the answer through trial and error and posted it what appears to be a split second before you and fluff. I edited my response cause it was weird to answer my own question and use the solution on my post rather than yours. But yes it may confuse some lol

 

[Fluff]

@vbaNumpty
In future please do not edit your posts after other members have posted. It just cause confusion, so I have changed it back.

 

[vbaNumpty]

@vbaNumpty
In future please do not edit your posts after other members have posted. It just cause confusion, so I have changed it back.

will do! Sorry

 

[Fluff]

I edited my response cause it was weird to answer my own question and use the solution on my post

There is nothing wrong with that, in fact it's better to leave it that way, as it shows your are trying to sort things out yourself.