If I follow what you are trying to do the answer is no. You can't change a
named range to refer to cells on whatever sheet happens to be active
(actually there is a convoluted way but not viable for what you have in
mind).

What you can do is have identically named Worksheet level names. These named
ranges could refer to similar cell references on each sheet. However that
will still mean a set of names for each sheet.

To create a Worksheet level name

ActiveSheet.Names.Add "myName", theRange
Manually, prefix the name with SheetName!, eg

Sheet1!myName ' if it fails embrace the sheet name with apostrophes

Regards,
Peter T

wrote in message
...
Ok, it's working now !@#$
It's working as long as the named ranges are specific to the sheet
(ie., have the sheet's name in the range def like ='Period 2'!$AW
$13:$FB$13,'Period 2'!$AW$15:$FB$15,'Period 2'!$AW$17:$FB$17,'Period
2'!$AW$19:$FB$19,'Period 2'!$AW$21:$FB$21,'Period 2'!$AW$23:$FB
$23,'Period 2'!$AW$25:$FB$25,'Period 2'!$AW$27:$FB$27)

I was just trying to do it so didn't have to make 3 named ranges on 7
different sheets. If it's possible to make 3 global ranges (without
specifying 'Period__'!) for use across multiple sheets, just let me
know.

Your time and advice is very much appreciated.