Also see the Formulas > Troubleshooting page.
search link, "An-xlfn-prefix-is-displayed-in-front-of-a-formula"
User Defined Functions = #NAME!
You cannot have the code module the same name as the user defined function
VBE Refresh Bug
link - fastexcel.wordpress.com/2011/06/13/writing-efficient-vba-udfs-part-3-avoiding-the-vbe-refresh-bug/
Every time a user defined function is updated the VBE title bar has [Running] appended to it.
Once the UDF function has completed the title bar reverts back to what it was before.
This updating of the title bar is unnecessary and will slow down your user defined function(s).
To avoid this happening close the VBE Editor then save and close the workbook.
You can also see a speed improvement when you initiate the calculation from VBA using Application.Calculate
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext