Monthly Archives: May 2019

Backward Compatibility of Office 365 Dynamic Arrays (Updated 23 Sep 2020)

Office 365 Excel Dynamic Arrays are great, but: What happens when you create a workbook with Dynamic Array¬† Excel (Excel DA) and send it to someone who does not have Excel DA, and how do you write VBA code that … Continue reading

Posted in arrays, Dynamic Arrays, Excel, Uncategorized, VBA | Tagged | 18 Comments

Excel Summit South 2019

If you can get to Australia in July/August check out the Excel Summit South 2019 conference. http://excelsummitsouth.com/ There is a great list of speakers and a chance to discuss Excel with a Microsoft Dev Team member and a host of … Continue reading

Posted in Uncategorized | Leave a comment