New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel for Mac giving me #VALUE! for everything


Post Reply New Thread Subscribe

 
Thread Tools
glossolalia

 
Member Since: Jun 12, 2011
Posts: 2
glossolalia is on a distinguished road

glossolalia is offline
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
QUOTE Thanks
BrianLachoreVPI

 
BrianLachoreVPI's Avatar
 
Member Since: Feb 24, 2011
Location: Maryland
Posts: 3,742
BrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant future
Mac 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

BrianLachoreVPI is offline
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
QUOTE Thanks
glossolalia

 
Member Since: Jun 12, 2011
Posts: 2
glossolalia is on a distinguished road

glossolalia is offline
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.
QUOTE Thanks
BrianLachoreVPI

 
BrianLachoreVPI's Avatar
 
Member Since: Feb 24, 2011
Location: Maryland
Posts: 3,742
BrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant futureBrianLachoreVPI has a brilliant future
Mac 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

BrianLachoreVPI is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Ichat | Font Issues in MS Word »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Can't open big Excel workbook on MacBook Air SergeiV OS X - Apps and Games 1 06-01-2010 04:01 AM
MAC excel 08 vs PC excel 07 gcookie OS X - Apps and Games 2 05-30-2010 11:32 PM
Excel - quits automatically and gives error report I don't understand aprildentist OS X - Apps and Games 1 09-28-2009 01:21 PM
Updating Excel document over a network? Garnon OS X - Apps and Games 3 05-26-2009 03:41 AM
Changing serial for Excel for Mac pegasus OS X - Apps and Games 1 04-08-2008 09:27 AM

All times are GMT -4. The time now is 03:44 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?