.. But why would one want a volatile function when one is not called for?

You're taking it further than what was asked by OP as the crux issue.
This wasn't mentioned by OP as an exclusion.

OP said:
I would appreciate any ideas how to do this.

And I merely ventured an option for OP to address his/her crux. That's it.
Ok, so yours is better. But man, did I ever contest that? Look again.

Why would the OP double post and never respond back
that 1/all of the proposed solutions actually worked for them?

OPs are not always as gracious as we would like them to be, I'd guess, John.
As an OP I'd always be gracious to all responders to my query, and I'd thank
& reply to each and every response received in my thread.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"John C" <johnc@stateofdenial wrote in message
...
As stated, volatile functions, such as OFFSET, definitely have their uses,
and in fact, there are many times where one would want/prefer a volatile
function. I have a workbook that I use very often every day that does
want/need the OFFSET function, and I use it gladly. But why would one want
a
volatile function when one is not called for? Why would the OP double post
and never respond back that 1/all of the proposed solutions actually
worked
for them?
--
** John C **