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…
Tag: array
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…
Top