If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VLOOKUP in VBA
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 ? |
Thread Tools | |
Display Modes | |
|
|