<code class="vb_keyword1">With
Range(
"
A2:C21
")
SetobjCell
=
.
Find(What:
=
"
170
", After:
=ActiveCell, LookIn:
=xlValues, LookAt:
=xlPart, SearchOrder:
=xlByRows, SearchDirection:
=xlNext)
If
NotErr = 0
ThenPremAdresse
=objCell
.
Address
Do
IfPlageResult
Is
Nothing
Then
SetPlageResult
=objCell
Else
SetPlageResult
=Application
.
Union(objCell, PlageResult)
End
If
SetobjCell
=
.
FindNext(objCell)
Loop
While
NotobjCell
Is
Nothing
AndobjCell
.
Address
<
>PremAdresse
End
If
End
With</code>