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