Tag: array

VBA Excel – How to convert range to array easily

Converting a range to array makes a lot of sense in VBA, when some operations should be performed with data in a given range. The time saving is quite noticeable and it is a bit easier to access and modify

Tagged with: , , , ,

VBA – Displaying the available AddIns in Excel

With the current article, I simply present a good way to list all the AddIns you have in MS Office, using VBA.   Pretty much, I declare a string array and I redimensionize it. Then for each addin in the

Tagged with: , ,