VBA custom function calls .net function and fails. Help?

[Steve Roth]

Hi all:

The following VBA function works in Windows Excel but gives a #Value! error in Mac Excel. My spreadsheet's attached, very simple.

Please Login or Register  to view this content.

I'm guessing this call to a .NET function is the culprit?

Please Login or Register  to view this content.

Can anyone tell me how to make this work, if it's possible? Do I need to do the following eg, and if so which one on this page??

https://learn.microsoft.com/en-us/do.../install/macos

Thanks as always for your incredible help.

Steve

[zbor]

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window.

I've add it now for you.

[Steve Roth]

Done. Code tags entered. Thx.

[EXCELGAARD]

Yep, it is a Mac issue - the library does not exist on a Mac - everything works fine in Windows.

You gotta find another way to do it on Mac - sorry, can't help you, since I'm on Linux/Windows.

[Steve Roth]

Thanks to all for considering this. FYI I found a (Google Sheets) solution. Enter a column of email addresses, get hashes for each. Apparently Google has a script library for this.

Courtesy of @pgSystemTester over at:

https://stackoverflow.com/questions/...-vba-or-macros

Here's the Google sheet:

https://docs.google.com/spreadsheets...&fvid=67067640

Thanks again,

Steve