Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
34
Views
Topic starter
I have the attached code for a function to calculate LOESS smoothing but need help to run the function using a Macro. Any help will be appreciated
Posted : 03/02/2021 9:07 am
Hi Mourad,
You will have to provide an excel file, with sample data that is required for those 4 arguments of the function you mentioned.
The function returns an array, unidimensional, so you can load the results to sheet:
Dim Arr as Variant
Arr=Loess(arg1,arg2,arg3,arg4) 'you have to provide the ranges and parameters required
Load to sheet:
Activecell.Resize(1,ubound(Arr))=arr
Posted : 04/02/2021 12:28 pm