View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RPJ RPJ is offline
external usenet poster
 
Posts: 2
Default 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