Hi I have a workbook with multiple worksheets. For each worksheet I
need to define a range of cells (called for example TestRange), but the
range of cells to be defined with this name on each worksheet can
differ. I have tried to define a cell range with the same name on
mulitple worksheets but it doesn't work as excel just returns you to
the first worksheet where the range was defined. However I did however
notice that if I make a copy of worksheet with the defined cell range
then it is possible to have multiple worksheets with the same named
cell range.

However all of my spreadsheets are already set-up so I don't want to
have to set them up again from scratch again as this will take me a lot
of time.

Is there an alternative way to achieving my objective with having to
make copies of of the original worksheet with the defined cell range?

Any help would be much appreciated.

Cheers
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=526300