Explanation Code

[alone]

Hello
Could anyOne explain this part of the code
if not intersect (target,range("c1") is nothing then

and the same code

If Not FoundCell Is Nothing

I have tried several times to their understanding, but I failed
I hope that I find it explains me in detail, especially as I am newbie in programming

 

[VoG]

Hi.

If Not Intersect(Target, Range("A1:A5")) Is Nothing Then

Target is in the range A1:A5.

Set FoundCell = Cells.Find(what:="A word")
If Not FoundCell Is Nothing Then

The search term was found.

 

[alone]

I'm sorry, Peter
I want to understand, word for word
So I can write sentences serve My Codes

 

[VoG]

Take the second example. If the search term isn't found, FoundCell is set to the value Nothing. to check that the value is not Nothing we need to use the Not operator.

 

[alone]

Hi.

If Not Intersect(Target, Range("A1:A5")) Is Nothing Then

Target is in the range A1:A5.
.

Peter
on the same logic,the second one

thank you

 

[VoG]

From the Help on the Intersect method

Returns a Range object that represents the rectangular intersection of two or more ranges.

In the example, if Target is not in the range A1:A5 the result of Intersect is Nothing. To check if Target is in the range A1:A5 we need to test for Not Intersect(...) Is Nothing.

 

[alone]

Thank you very much
I deeply appreciate this information