Back to Blog
Define sub in excel vba on mac6/24/2023 ![]() It is global in the sense that it is automatically enabled to every Excel file running in your machine. Luckily Microsoft provides a way to create Global UDFs. And that is really not fun and a potential bigger issue with multiple revisions of the same functions running around your file system. The second reasons is that if you decide to improve the UDF, you now have to go back to each Excel file and manually implement the change in the UDF again. Additional manual steps to do every time you create a new Excel file. And that is not really great from couple of reasons: First it is annoying. The user defined function (UDF) is available for this specific Excel file and works as you would expect.īut what happens when you need to create a new Excel file that also needs to use the same UDF?įor now, you simply have to re-create the UDF manually in every Excel file you create. Let’s assume you developed a great user defined function (See here and here).
0 Comments
Read More
Leave a Reply. |