How to make spreadsheets more efficient

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
pgetty
Posts: 5
Joined: Sat Dec 22, 2018 6:56 am

I have started my attempt to move all my formulas into VBA and have a few quick questions to make sure I am going down the right path.

Should I use arrays with 3+ dimensions or stick to 2?
I have declared a public array. Is there a way to view this similar to how you you would view a private array in the locals window?
I have googled how to index/match in arrays and from my reading it suggests the best way is to loop through all the data. Is this the best way or is there a better way?

Thanks
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”