Why I am creating this thread:
Firstly I should make clear that I am not the best qualified to write this thread (I only started learning arrays less than a month ago). I am creating this thread because I recently had an urgent need to rapidly learn how to use arrays and I was greatly helped by Excel Forum users so I wanted to give back in some small way. Hence this thread.
What this thread is:
A list of functions to allow array newbies (such as myself) to create/manipulate/write 1D & 2D arrays without requiring expert knowledge on how to work with arrays.
As I am new to arrays, I have no doubt that this code greatly needs improvement.
As such, I take no responsibility if the code doesn't do what you expect - in other words, use at your own risk
If you are experienced with arrays and can see anything that should change, please post in this thread so I can update the code. Thank you.
I will try to update this thread soon to include some brief instructions on what the functions do and how best to apply them.
Arrays Function Module No 1 (This deals with reading/writing arrays to/from Active/Closed/New workbook)
Please Login or Register to view this content.