I was running a user defined function in Excel 2007, is working fine but when i apply in excel 2000 it was
failed and with the result #values!
Would it be the coding below cannot run at excel 2000? Any setting to run the
UDF in excel 2000?
Thanks and appreciate your help.
Below is the function created:
Function LookupAll(vVal, rTable As Range, ColumnI As Long, ColumnII As Long, ColumnIII As Long) As Variant
Dim rFound As Range, lLoop As Long
Dim strResults As String
Set rFound = .Cells(1, 1)
For lLoop = 1 To WorksheetFunction.CountIf(.Cells, vVal)
Set rFound = .Find(What:=vVal, After:=rFound, LookIn:=xlFormulas, LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
strResults = strResults & "; " & rFound(1, ColumnI) & "," &
rFound(1, ColumnII) & "," & rFound(1, ColumnIII)
LookupAll = Trim(Right(strResults, Len(strResults) - 1))