View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tonys7340 tonys7340 is offline
external usenet poster
 
Posts: 2
Default Defined name value error

I have created a defined name for a cell b5 containing a phone # and named it
"Phone". When I want to access it by typing " =Phone" , I get a value error.
Of course when I type "=b5" I get the correct value ( the phone #). I have
this problem with all of the defined names that I have created in the
workbook. Any idea what the problem is?