Hi all,
I trying to use the Excel Trend function in Access.
I found some code that works for the Median function
Public Function getMedian(ParamArray aNum())
getMedian = WorksheetFunction.median(aNum)
End Function
The getmedian then works with commas between the values. The trend function requires a range of cells so I am not sure how to start.
Anybody any ideas ?
I trying to use the Excel Trend function in Access.
I found some code that works for the Median function
Public Function getMedian(ParamArray aNum())
getMedian = WorksheetFunction.median(aNum)
End Function
The getmedian then works with commas between the values. The trend function requires a range of cells so I am not sure how to start.
Anybody any ideas ?