User Defined Function (UDF)

[FilleFrella44]

Hello everyone!

I've recently gotten to understand that you're able to create your own functions by taking an Excel-workbook, adding some VBA "Functions" to it in modules, and then save and load it as an Add-in into Excel.

Now this is so amazing, a real game-changer. But, what I want to know is: What are your favorite UDFs? Want to share?

Regards,
FilleFrella

 

[FilleFrella44]

I had no idea what the reasoning was behind XLSB and XLSX, nice input!

 

[jdellasala]

A couple of months ago I posted Enabling Excel 4.0 macros and their use in a LAMBDA function. I had seen a video on creating hyperlinks to worksheets, and had found that although it didn't use LAMBDA, I was able to create a function by assigning a name to the formula

=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")&T(NOW())

which lists all Worksheets. I had gotten the basis of the formula from this YouTube video which was a couple of years old, and ran into a problem getting the Named function to work. I found an MS Support doc - Working with Excel 4.0 macros which showed me how to get the function to work.