VBA arrays

Hi Bart,

Thank you for the forum question.


500MB for 32-bit VBA and about 4GB for 64-bit VBA (Excel 2010 - 2013). The only limit in Excel 2016 is the computer's memory size.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector