VLOOKUP in VBA
Sorry, Niek, doesn't make any difference
Gilbert
"Niek Otten" wrote in message
...
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 ?
|