That should work for you... The only thing to look out for is that it will
potentially unload depending how errors are handled...

HTH

"John Wirt" wrote:

I want to store a range in a public variable that lasts as long as the
workbook is open.

Will this declaration in a Module header accomplish this:

Public RA as Range

Sub XXX...
Set RA=Range("A1")
....

The scope of this variable is the project. What is its lifetime?

John Wirt