declaring public array?

[desertsp]

I have a workbook which refers to the same set of cells in several sub procedures. Since I'm pretty new to VBA, I wound up creating an array to store the contents of those cells. Also since I'm new, I'm "recreating" the same array in each sub procedure, rather than creating it once for the module and then having each procedure access the existing array. Since one of these sub procedures is event triggered (mousemove) I think it's really slowing down my code.

Can anyone help me change my code to create the array one time and make it available to all the procedures?

Thanks!

Here's a sample of my existing code with just two of the procedures:

Please Login or Register  to view this content.

[patel45]

declare array before all subs

Please Login or Register  to view this content.

[desertsp]

That seems to have done the trick. Unfortunately it didn't speed up the code noticeably.