sharing an array between worksheets
Hi
I have a module which runs when a sheet is opened. That
gets some information and then populates an array (defined
as public within the module). That all works fine, but if
I try to access the contents of the array from any of the
subsequent sheets, I get an error saying an array was
expected. Why can't the sheets see it even though it's
defined as public in the module?
Thanks for your replies.
Peter
|