New Member
June 20, 2021
I have a UDF (created by others) Tri_Wave(t, V1, V2, T1, T2) which is coded as such in VBA but is keyed into the spreadsheet cell as: =@Tri_Wave((A16;$H$8;$H$9$H$10;$H$11). The function works correctly but I don't understand why the VBA coding differs from the UDF typed into the cell. Why is there a @ in front of the UDF when typed into the spreadsheet cell?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Hi David,
Your answer is here: https://support.microsoft.com/.....#038;ad=us
=MYUDF() | =@MYUDF() |
Implicit intersection could occur. User Defined Functions can return arrays. When they do, the original formula would have triggered implicit intersection. |
I suggest changing your function declaration, as it is now returns a Variant type, while it seems to be a decimal number:
Function Tri_Wave(t, V1, V1, T1, T2) as Double
1 Guest(s)