Encapsulated functions in Excel VBA

[Shay A]

Hi everyone
Is it possible to use a function within a function in my code?
For example,

application.worksheetfunction.ifna(vlookup(A2,My_Array,2,0),"qqq)

Thanks in advence!
Shay

 

[chirayu]

its is possible but the vlookup will be application.worksheetfunction.vlookup

 

[Stevie]

You may consider writing your own function which combines the two if it is something you need regularly:

Function func1(a As Range, b As Range, c As Integer, d As Integer, e As String)
    func1 = Application.WorksheetFunction.ifna(Application.WorksheetFunction.VLookup(a, b, c, d), e)
End Function