variable scope

  • Thread starter Thread starter mgasparel
  • Start date Start date
M

mgasparel

no chance i could get a variable's scope to include two separate
worksheets is there?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Duplicate declaration in current scope" during edit and continue 1
Code Snippet - Data Filter 8
Reference a workbook level named variable. 8
Delete named ranges in VBA - by scope? 2
Global/Public/Universal variables 8
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Possible scoping problem 8
Defining public/global variables in more than one place 1

Back
Top