Category Archives: Mac

Mac Excel vs PC Excel

Here’s a summary of my work on a Mac with Excel 2011, trying to make an existing Excel 2007 addin compatible with it. There are quite a few incompatibilities. The main ones are: 1) No RibbonX menu, you have to … Continue reading

Posted in Excel/VBA, Mac | Leave a comment

More differences between Excel for Windows and Excel 2011 for Mac, mainly VBA

For the official MS list of differences see http://mac2.microsoft.com/vb/1033/Excel/html/xlmscChangesBetweenExcel2010and2011.htm “The following is a summary of the diffferences in the Microsoft Excel 2011 for Macintosh visual basic object model as compared to Microsoft Excel 2010.” Here’s my own list, the last … Continue reading

Posted in Excel/VBA, Mac | Leave a comment

List of Mac Excel 2011 differences from Excel 2007

1) DIR() returns error rather than null string, so trap it 2) rg.Find Searchformat named argument not found Same for ReplaceFormat 3) rg.Autofilter Help says “If you omit all the arguments, this method simply toggles the display of the AutoFilter … Continue reading

Posted in Mac, Risk | 1 Comment