|
'----------------------------------------------------------------
Function YK(search_ As Variant, rngY As Range) As Variant
'----------------------------------------------------------------
'Dim search_ As String: search_ = "홍길동1" ' [E1].Value
Dim varX As Variant: varX = rngY.Value
For i = 1 To UBound(varX, 1)
If varX(i, 1) = search_ Then
varX(i, 1) = search_
Else
varX(i, 1) = ""
End If
Next i
' Stop
YK = varX
End Function '
'----------------------------------------------------------------
Sub Y()
'----------------------------------------------------------------
Dim search_ As String: search_ = "홍길동1" ' [E1].Value
Dim varX As Variant: varX = [B3:B14].Value
For i = 1 To UBound(varX, 1)
If varX(i, 1) = search_ Then
varX(i, 1) = search_
Else
varX(i, 1) = ""
End If
Next i
' Stop
[E3].Resize(UBound(varX, 1), 1).Value = varX
End Sub
|
|