no chance i could get a variable's scope to include two separate worksheets is there?
no chance i could get a variable's scope to include two separate worksheets is there?
sorry... two separate workBOOKs is what i meant
I believe if you create a reference in Book1 to Book2, you can then
access the Book2 public variables in Book1 with Book2.publicvariable.
Assuming the above works, why would you want to do that? It is enough
of an invitation to problems having a public variable within a workbook
without extending the 'scope' to multiple workbooks. {shudder}
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <[email protected]>,
[email protected] says...
>
> no chance i could get a variable's scope to include two separate
> worksheets is there?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks