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 Raiminius wrote:
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

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.