VBA - True or False, if string is found

Question

I'm trying to get a True or False, depending on, if a string is found in the worksheet "fal".

Dim stress As Boolean
If fal.UsedRange.Find("Approach = STRESS") > 0 Then
stress = True
Else
stress = False
End If

It gives a "Run-time error '91': Object variable or With block not set"

Any ideas?

can you post the complete code? 'fal' is the name of your worksheet? have you referenced it in a variable ? — gaurav5430
– gaurav5430, Commented Mar 13, 2014 at 8:33

Dmitry Pavliv · Accepted Answer · 2014-03-13 08:34:50Z

3

Try this:

Dim stress As Boolean
stress = Not fal.UsedRange.Find("Approach = STRESS") Is Nothing

answered Mar 13, 2014 at 8:34

Dmitry Pavliv

35.9k13 gold badges84 silver badges85 bronze badges

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

3 Comments

Trenera Over a year ago

This works perfect! Thanks! I can accept the answer in 5 mins, after I am allowed to.

Trenera Over a year ago

Actually No... It says that stress = False, when the string is obviously there...

Dmitry Pavliv Over a year ago

@ViharChervenkov, see my updated answer - you should use stress = Not fal.UsedRange.Find("Approach = STRESS") Is Nothing - note there is Not before fal.UsedRange.Find

Collectives™ on Stack Overflow

VBA - True or False, if string is found

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