ExcelBanter - dimensioning across modules

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - dimensioning across modules (https://www.excelbanter.com/excel-programming/323376-dimensioning-across-modules.html)

Papa Jonah

dimensioning across modules

I have a range that is currently dimensioned in Mod 2 and want to be able to
reference it while vba is in mod 14. Is this possible? What is the key word
to let that happen? Public does not appear to be it.

TIA

Bob Phillips[_6_]

dimensioning across modules

Public is it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Papa Jonah" wrote in message
...
I have a range that is currently dimensioned in Mod 2 and want to be able
to
reference it while vba is in mod 14. Is this possible? What is the key
word
to let that happen? Public does not appear to be it.

TIA

All times are GMT +1. The time now is 04:09 PM.