How to Define a named Formula at the Worksheet level?
 

I know how to "Insert, Name, Define" a formula at the Workgroup level - but
how can I do this at the Worksheet level only?

The infuriating thing is that I have done this before but I cannot remember
how (or where I found out how to)!

Thanks in advance.

RPJ

How to Define a named Formula at the Worksheet level?
 

Prefix your name with the sheetname followed by exclamation mark. E.g.
Sheet1!myName.

HTH
Kostis Vezerides



RPJ wrote:
I know how to "Insert, Name, Define" a formula at the Workgroup level - but
how can I do this at the Worksheet level only?

The infuriating thing is that I have done this before but I cannot remember
how (or where I found out how to)!

Thanks in advance.

RPJ

How to Define a named Formula at the Worksheet level?
 

Thanks vezerid.

Only thirty minutes to get the answer - what a valuable resource this
Discusion Group is.

RPJ

"vezerid" wrote:

Prefix your name with the sheetname followed by exclamation mark. E.g.
Sheet1!myName.

HTH
Kostis Vezerides



RPJ wrote:
I know how to "Insert, Name, Define" a formula at the Workgroup level - but
how can I do this at the Worksheet level only?

The infuriating thing is that I have done this before but I cannot remember
how (or where I found out how to)!

Thanks in advance.

RPJ