no chance i could get a variable's scope to include two separate
worksheets is there?


--
mgasparel
------------------------------------------------------------------------
mgasparel's Profile: http://www.excelforum.com/member.php...o&userid=19670
View this thread: http://www.excelforum.com/showthread...hreadid=345901

sorry... two separate workBOOKs is what i meant


--
mgasparel
------------------------------------------------------------------------
mgasparel's Profile: http://www.excelforum.com/member.php...o&userid=19670
View this thread: http://www.excelforum.com/showthread...hreadid=345901

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 ,
says...

no chance i could get a variable's scope to include two separate
worksheets is there?