Hi,

I have no problem naming ranges of cells in XL. However, I have the
following scenario that I can't find a solution to:

Imagine you have 5 identical worksheets. You want to highlight a data range
which is also indentical in each worksheet.

Can you create 1 range name that applies to a range of cells on each
worksheet, rather than having to create 5 different named ranges (1 for each
worksheet)?

It is odd because if you have 1 worksheet, name a range, and then make 4
copies, they will all have the same range under the same name - so it must be
possible to do it the other way around?

You might say: if they are identical, then go back to just one, create the
named range, and then make 4 copies to get the 5 sheets. However this is not
feasible for me for reasons I can't really go into (work related).

I hope the above makes sense to people.

Many thanks in advance for any clues.

Pete