G
G.P.N.L. c.v.a.
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").Range("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 ?
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").Range("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 ?