View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christian Galbavy Christian Galbavy is offline
external usenet poster
 
Posts: 8
Default give cells the same name

Hello!

I want to do the following:
I have two sheets, let's say Sheet1 and Sheet2.
On every sheet I want to name the cells "A1" with "customer".
The problem is, when I name Sheet1!A1 and after that Sheet2!A1 the name
of Sheet1!A1 gets deleted. I know, how to do this with the SHIFT-Key,
but I do not want the cells to have a relation. So if I change Cell
Sheet1!A1, this should have no effect on Sheet2!A1. They should only
have the same name.
Thanks for any help.

Regards
Christian


*** Sent via Developersdex http://www.developersdex.com ***