Category Archives: Mac

Excel and PowerPoint 2016 for Mac gripes

I’ve been trying to maintain compatibility between Mac and Windows versions of Excel/VBA apps for a while now, and it’s a pain. These notes refer to versions 16.14 of both Excel and Powerpoint. Here are some of my recent threads … Continue reading

Posted in Excel/VBA, Mac, powerpoint, Uncategorized | Leave a comment

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