View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colts41 Colts41 is offline
external usenet poster
 
Posts: 8
Default Changing cell addresses to recently added names in existing formul

Filled several cells with formulae that uses data from various cells.
Subsequently assigned names to the data cells. Formulae still reflects
column+row addresses. Is there an easy way to update all of the cells with
formulae to reflect the assigned names as opposed to the cell address?

Relatively new to this site - enjoy reading the solutions to the questions
posted. Thanks to all who take the time to respond with help for those of us
in need.