Using arrays from different modules
Using arrays from different modules
(OP)
This question might seem trivial to many...I'm just not too familiar with VBA...Anyways, I have different modules set up, each creates an array of data that it reads from excel. I now need to use these arrays and be able to compare them and do some calculations. My idea was to create a new module, where I would call the arrays, but I don't know how to do this...Any help would be greatly appreciated...
Thank you,
JJBL
Thank you,
JJBL





RE: Using arrays from different modules
All you need to do is define your variable (arrays in this case) as public outside of the Subs and make sure you run the module where you define it before you want to use the variable in a different module...
RE: Using arrays from different modules