proper VBA Array Formula

[Gabriel222]

Hi All !

How can I make an "array formula" in VBA without "using" an actual "excel fomula"

I'm asking because I need the VBA to work regardless of the language of the Excel or of the environment.

so although "=SUM(DATEVALUE(A1:A555))" works, (and would work if I used it via VBA in an english context)

I need it to work in "pure" VBA, so that the VBA can work in every "language context"

Thanks for your help !

 

[James006]

Hello,

The definition of "pure" can be highly subjective and even completely arbitrary ... :wink:

If, thanks to VBA, you are looking for a generic explanation of Arrays (which could then be applicable to many different programming languages),

you can take a look at : https://excelmacromastery.com/excel-vba-array/

Hope this will help