Declare ABC as Double instead of Date

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"G.P.N.L. c.v.a." wrote in message
...
I am a beginner in VBA; nevertheless, I already have several working UDF's
in Excel 2003, though.

Why does TGI(A213) gives me "#VALUE!"
- while A213 contains "30/11/2013",
- the formula - in the right module - is :
Option Explicit

Function TGI(ABC As Date) As Single

TGI = Application.WorksheetFunction.VLookup(ABC, _
Range(Workbooks("INDEX.XLS").Worksheets("INDEX").R ange("DBINDEX")),
_
2, _
True)

End Function
- the range DBINDEX in the sheet INDEX in the workbook INDEX.XLS is
A2:G470,
and
- in that range cell A373 contains "30/11/2013" ?

Can somebody help me ?