Max,
Thanks.
Found it under the 'Formulas' tab, 'Define Name' section.

How can I find the post giving this technique from Harlan?

Greg


"Max" wrote:

Are you inserting a new worksheet
or using the Insert tab, in the top menu bar?

In my xl03, it refers to the menu command "InsertName",
to define named ranges
(not insert worksheet)

When I "Click Insert Name Define",
it opens a "Define Name" dialog
where the subsequent steps as mentioned are then done

Hope that clarifies it sufficiently for you
(I don't have/know xl07, hope the steps aren't too different)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Greggers" wrote:
Max,
Thanks for a prompt response, it looks good.
However I'm rather confused by the action described as :
"
Click Insert Name Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK
"
Are you inserting a new worksheet or using the Insert tab, in the top menu
bar?
Please explain

Thanks

Greggers