Gord

could well be a misunderstanding on my part, sorry if this caused any
confusion...

what I've done is add a defined name, but instead of using a range, I've used
a formula.

works the same (kind of) but has the advantage (when used locally) of
confining use of the function(s) to the relevant worksheets

S