ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Type mismatch: array or user-defined type expected (https://www.excelbanter.com/excel-programming/440922-type-mismatch-array-user-defined-type-expected.html)

Naftas

Type mismatch: array or user-defined type expected
 
Hi Everyone,

can you help with next problem. Here is variable declaration in sub rutine:

Sub PVT_OIL_PB(ByVal TPB As Double, ByVal GAMAGPB As Double, ByVal GAMAOPB
As Double, ByVal PSPB As Double, _
ByVal GORPB As Double, ByRef CAPB() As Double, ByRef APB() As Double)

Here is call statment for Sub PVT_OIL_PB :

Call PVT_OIL_PB(t, GAMAG, GAMAO, PS, GOR, CA(), a())

After calling rutine i have recived next error message:

"Type mismatch: array or user-defined type expected"

Where is my mistake?

Best regards,
Naftas




All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com