sonu
07-05-2005, 01:26 PM
How do I use find function in UDF.
The following line does not work in a function listed below
find_val = Range("H:H").Find("abc")
Function find_val(va As Variant)
find_val = Range("H:H").Find("abc")
End Function
but when I put it in a sub procedure it works fine
sub test
find_val = Range("H:H").Find("abc")
end sub
Can someone help
Thanks.
:dunno
Sonu
The following line does not work in a function listed below
find_val = Range("H:H").Find("abc")
Function find_val(va As Variant)
find_val = Range("H:H").Find("abc")
End Function
but when I put it in a sub procedure it works fine
sub test
find_val = Range("H:H").Find("abc")
end sub
Can someone help
Thanks.
:dunno
Sonu