Excel for Mac giving me #VALUE! for everything

Hi guys,

I have a spreadsheet that was originally made for PC's (I'm assuming) and I'm trying to use it on a Mac. Thing is, the sheet uses a custom function and some of the formulas are kind of complicated. I've attached the worksheet below.

Two examples are:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Could it be that the formulas are supposed to be written differently on a Mac vs. a PC? If so, could someone point me in the right direction? If these are written incorrectly, how would I change them to make them valid for Excel on Mac?

Thank you,

Brandon

Originally Posted by TMShucks

I don't know anything about Excel on a MAC but the spreadsheet you have provided has no VBA code in it, hence no custom function ... hence NAME and VALUE errors.

Regards

Well, that was just one sheet of the original file. I've attached the original file this time. Note that it requires Credentials on the second sheet, which are not provided. But even when I enter the correct credentials, I get the same error. I'm pretty sure it's something to do with the way the formulas are written, and how they differ on a Mac vs. a PC. I just don't know how to correctly write them for Macs.

Originally Posted by martindwilson

its the code the formula bit works fine if you type something in that it can find
put
y"us"ah,oo.com
in b10 and c10 returns "h"

I don't understand your suggestion. I need to check for the site "yahoo.com." Why can't I just enter yahoo.com normally in A10?

Originally Posted by TMShucks

I think what Martin is explaining is that the formula is fine. You are getting #VALUE! errors because the UDF has not been executed, hence the formula is not finding what it is looking for in the cell (B10, etc). If you put in something that "looks like" the output from the UDF, then the formula extracts what it wants, whether that's "us" or whatever.

My understanding is that not all versions of Excel for MAC support macros so it may be that you cannot use this workbook on your MAC

Well, when I open the file, Excel asks me whether I want to enable macros and I select Yes. I'm assuming that means my version of Excel is compatible with macros.

And the only input the user is supposed to enter is the URLs in column A. There should be no tinkering with column B. I just don't know why the URLs aren't triggering a response in column B.

Originally Posted by TMShucks

Have you input the credentials on the Credentials sheet?



Regards

Yes.

I'm almost positive the problem is either with this code:

Please Login or Register  to view this content.

Or that Excel isn't properly reading the VBA code.