Edit a Name in Name Manager in Excel ?

[Yugal Jindle]

I have a Name 'FomulaName' in the Name Manager in my Excel file.


I want to edit the value of the FormulaName name.


I have :

Dim sheet Excel.Worksheet = getSheet()
sheet.Names('FormulaName') ' This gives error


How can I edit the value of FormulaName name in the Name manager ?


Please Help !

 

[JohnH]

Access the Names collection from the Workbook object, rather than from Worksheet object.