[RESOLVED] Make a function return a array

Hi. I want my function to return a array.
I got this error: Compile error: Type Mismatch.

This is my code:

Code:

---



Public Function RegistaNBCobranca(Entidade As Integer, ContaBancaria As String, TipoDoc As String, Serie As String, NumDoc As Long, Prestacao As Integer, Valor As Double, DataDoc As String) As String
Dim Recibo As GcpBEDocumentoLiq

Dim Retorna(1 To 2) As String

With Recibo
    '....
    '....
    Retorna(1) = .NumDoc
End With
Retorna(2) = Recibo.Serie
RegistaNBCobranca = Retorna()
End Function

---

What's wrong with my code?

What is GcpBEDocumentoLiq?

How do you call your function?

What line causes the error?

Modify this as

Code:

---

Public Function RegistaNBCobranca(Entidade As Integer, ContaBancaria As String, TipoDoc As String, Serie As String, NumDoc As Long, Prestacao As Integer, Valor As Double, DataDoc As String) As String

'--Add this
Public Function RegistaNBCobranca(Entidade As Integer, ContaBancaria As String, TipoDoc As String, Serie As String, NumDoc As Long, Prestacao As Integer, Valor As Double, DataDoc As String) As String()

Dim Recibo As GcpBEDocumentoLiq

Dim Retorna(1 To 2) As String

With Recibo
    '....
    '....
    Retorna(1) = .NumDoc
End With
Retorna(2) = Recibo.Serie
'--RegistaNBCobranca = Retorna()
'--Add this
RegistaNBCobranca = Retorna

End Function

---

Public Function RegistaNBCobranca(Entidade As Integer, ContaBancaria ...., DataDoc As String) As String()


End Function

Hi. 1st: GcpBEDocumentoLiq is a type of data.
2nd: I got the error in the line last line:

Code:

---

RegistaNBCobranca = Retorna()

---

3rd: When i try to compile (it's a dll) i got that error of type mismatch.
Thanks.

Ok. Thats resolved. It was the lack of ().
Thank you all for your quick replyzz. :wave:

The easiest and best way to mark a thread resolved is to pull down the Thread Tools menu and click the Mark Thread Resolved menu item. :)