public array
I am having a little trouble following your answer Bob. Normally you are much
more lucid than I am.
tMonths is global and can be read from or written to by any macro. So just
remove the Dim statement and you are off to the races.
HTH
"Bob Phillips" wrote:
If you just declare it Public outside of the macro, and remove the same
variable in the macro, then the other macro can use that same macro.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Circe" wrote in message
...
First off I notice that you have declared tMonths both Public at the top
of
the procedue and again within the procedure. The Dim tMonths will
override
the Public tMonths and your public variable will not be initialized.
And how can i pass to another macro the array??
|