Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

amusmani

macrumors newbie
Original poster
Oct 22, 2011
2
0
Hi,

I am having problems using an excel sheet that has a lot of VBA code and contains user defined functions. I have MS Office 2011 so the VBA is supposed to work. The workbook and functions works perfectly with a windows computer but when I use it on my Mac "VALUE" just shows up the cell.

Excel recognizes that the function exists and also lists the inputs for the function but it cannot evaluate it. I would appreciate any advice.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.