Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Range on different worksheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
same range names in different worksheets | Excel Worksheet Functions | |||
Range of Worksheets Sum | Excel Worksheet Functions | |||
Macro with Range of Worksheets | New Users to Excel | |||
SUMIF across a range of worksheets | Excel Worksheet Functions | |||
VBA help - worksheets and range questions | Excel Programming |