Results 1 to 4 of 4
  1. #1


    Member Since
    Jun 12, 2011
    Posts
    2
    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.

    Two examples are:

    Code:
    =GetURLmetrics(A10,TRUE)
    and

    Code:
    =MID($B10,(FIND(C$9,$B10)+LEN(C$9)+1),(FIND(",",$B10,(FIND(C$9,$B10)))-FIND(C$9,$B10)-(LEN(C$9)+1)))
    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

  2. #2

    BrianLachoreVPI's Avatar
    Member Since
    Feb 24, 2011
    Location
    Maryland
    Posts
    3,733
    Specs:
    March 2011 15" MBP 2.3GHz i7 Quad Core 8GB Ram | Mid 2011 27" iMac 3.4 GHz i7 16 GB RAM 2 TB HDD
    I don't think it has anything to do with PC vs Mac in the Excel code - it probably stems from whatever GetURLmetrics was supposed to be. Is that a VBA function call? I don't see it in Excel and in fact - when I google that - all I find is your thread at the Excel forums here Excel for Mac giving me #VALUE! for everything - Excel Help Forum with the same question. As long as you're spreading the love - why not try here Office for Mac - Excel Forum

  3. #3


    Member Since
    Jun 12, 2011
    Posts
    2
    Hi Brian,

    The original file had Macros (it was a .xlsm) which can be found here:

    http://www.businesshut.com/wp-conten...API_beta1.xlsm

    For some reason I couldn't attach it, but if you're curious to see it, that should explain the custom function.

  4. #4

    BrianLachoreVPI's Avatar
    Member Since
    Feb 24, 2011
    Location
    Maryland
    Posts
    3,733
    Specs:
    March 2011 15" MBP 2.3GHz i7 Quad Core 8GB Ram | Mid 2011 27" iMac 3.4 GHz i7 16 GB RAM 2 TB HDD
    Looks to be definitely a VBA macro - actually 2. I take it you've grabbed this excel file from somewhere are are trying to tailor it to your own needs? I definitely recommend you visit the Office for Mac forum I linked to. I don't really tinker with VBA.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel for Mac and Excel for Windows
    By newbimac in forum OS X - Apps and Games
    Replies: 5
    Last Post: 09-23-2015, 01:34 PM
  2. Simple Excel problem - number pad giving directions
    By toMACsh in forum OS X - Apps and Games
    Replies: 15
    Last Post: 09-27-2013, 09:13 PM
  3. Giving old Mac to a friend
    By curly0107 in forum OS X - Operating System
    Replies: 2
    Last Post: 11-10-2012, 03:36 AM
  4. Replies: 4
    Last Post: 03-31-2009, 11:49 PM
  5. Apple giving up Mac and im going..
    By maccernow in forum Schweb's Lounge
    Replies: 3
    Last Post: 03-12-2008, 09:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •