View Single Post
  #1   Report Post  
Pierre
 
Posts: n/a
Default same Named cells in different sheet


Hi all,
In a macro I use a named range. I want to use the same macro in similar
sheets in the same workbook. But each time I name the same range in
another sheet, the first one is canceled. How can I create the name in
all the sheet ?

It is probably possible as when you copy a sheet in the same workbook,
you have the same name in all the sheets.

Thanks



--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=396828