set variable to activeworkbook

  • Thread starter Thread starter davegb
  • Start date Start date
D

davegb

A question occurred to me about setting a variable to the active
workbook. If I set the variable equal to "Activeworkbook", then later
activate another workbook, does the variable now refer to the current
active workbook, or to the same workbook as when it was assigned?
 
Hi Dave,

the variable is set to what it was set. (same workbook as it was
assigned).

You could easily test it yourself.

Regards,
Ivan
 
Ivan said:
Hi Dave,

the variable is set to what it was set. (same workbook as it was
assigned).

You could easily test it yourself.

Regards,
Ivan
Click to expand...

Thanks for your reply, Ivan. I thought about testing it, but was afraid
that it might vary under differing conditions. If so, a simple test
might not give totally accurate results.
 
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

Variable refers to a workbook 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Setting a variable = ActiveWorkbook 8
Passing Variables between Workbooks 3
Save ActiveWorkbook dilemma 3
Need code to close minimized workbooks in BeforeClose event 3
out of memory error 3
Copy from one workbook to another failing 8

Back
Top