Thread: Cell name
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Cell name

BEFORE eliminating the Cheezeburger, do a "Fnd and Replace" to get it out of
the formulas and replace it with A1

Vaya con Dios,
Chuck, CABGx3



"mattflow" wrote:


Thanks Chuck, but when I do this then the cells referencing
"Cheeseburger" still reference "Cheeseburger", so while deleting the
cell in this way does fix one problem, it then leaves me with many
name? errors.

CLR Wrote:
Insert Name Define select "Cheezeburger" in the lower window
Delete

Vaya con Dios,
Chuck, CABGx3



"mattflow" wrote:


Lets say cell A1 is named "Cheeseburger", what is the easiest way to
delete the name so that cell A1 is now simply A1?


--
mattflow

------------------------------------------------------------------------
mattflow's Profile:

http://www.excelforum.com/member.php...o&userid=25129
View this thread:

http://www.excelforum.com/showthread...hreadid=501662




--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=501662