Search results for query: *

  1. Y

    Edit a Name in Name Manager in Excel ?

    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 ...
  2. Y

    How to Replace formula with value in Excel cell ?

    I have complex formula calculating the value of a cell and it calculates the value for me. I want to get rid of the formula from the cell and want to retain the calculated value. I have : Dim range As Excel.Range = getRange() For Each cell in range ' What should do to retain the value and...
Back
Top