Mr Meshta, please allow me to return to this question for which you provided
an answer some months ago.

I'd like to use the named formula in sheets with quite long names. Is there
a way to adapt the formula in way that it will alwys work in the current
sheet (the sheet in which it is called), independent of the sheets name?

"Tushar Mehta" wrote:

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
thank you, this seems to be quite helpful. Nice website

{snip}