Array declaration

[Bernard Bourée]

I have some functions that should be used in a Addin Macro (.xla) under
Excel 2000 VBA but also in a VB6 module.

It seems taht the Array declaration is different :

Function MyFunction (Val as Range) as Double

for the Addin Macro

and

Function MyFunction ( Val() as double) as double

Is there a way to have the same decalartion that works in both case ?

 

[Jack D.]

I have some functions that should be used in a Addin Macro (.xla) under
Excel 2000 VBA but also in a VB6 module.

It seems taht the Array declaration is different :

Function MyFunction (Val as Range) as Double

for the Addin Macro

and

Function MyFunction ( Val() as double) as double

Is there a way to have the same decalartion that works in both case ?

Please try the microsoft.public.excel.programming newsgroup for this
question.
I think you will get more answers there.
This group is for microsoft project.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++