>Actually the above does not work. If I look in Excel, in Insert, Name, Define, there is still
>only one entry for LastDay. How can I get it so that it shows an entry for LastDay one
>each sheet?
>Thanks
>Steve

It doesn't seem to allow you to keep duplicate "Name" entries. If you name the range differently on each sheet, then you'll see separate entries in the Names collection.