Function requires range as a parameter, how to call from VBA ?

If it is an Excel add-in, how are you using it in Access? If it is by automating Excel, then you can pass a range from there; if you are not using Excel at all, then you cannot pass it a range. Are you sure it needs a range, and cannot take an array for example?

Originally Posted by OnErrorGoto0

If it is an Excel add-in, how are you using it in Access? If it is by automating Excel, then you can pass a range from there; if you are not using Excel at all, then you cannot pass it a range. Are you sure it needs a range, and cannot take an array for example?

Yes, im calling it via Excel, i.e.

ReturnValue = objXL.Run ("MyFunction", a, b, c)

where objXL is defined as Excel Application.




ps: Actually the description says it would take an array, but i assumed they mean cells, not an VBA array, but tbh i have little experience with arrays in VBA.

Well if your data is, or can be put, in a range, then you can pass that. If not, I would suggest passing an array to see if it works.