View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NHMM NHMM is offline
external usenet poster
 
Posts: 3
Default Cell Names in Two Sheets

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?