Great. You are welcome.

Now if you do want to work with closed workbooks or in separate instances...then you can download and install the Morefunc.xll addin from here:

http://download.cnet.com/Morefunc/30...-10423159.html

and then use INDIRECT.EXT in place of INDIRECT in the formula I supplied...

Note: this addin can be embedded into the workbook so that it is shareable without having to download addin again.