variable scope
 

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

variable scope
 

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

variable scope
 

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?