Hi Bob Philips
Two problems when I try your suggstion:
1. the naam Sheet3!name is not valid - because of the ! in it
2. even with another valid name like Sheet3name, the name still applies
only to the range in Sheet 3 and is visible visible in the namebox in
all sheets

I'm trying to give the same range on multiple sheets one name that will
apply to all sheets.

More suggestions?


--
digicat
------------------------------------------------------------------------
digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920
View this thread: http://www.excelforum.com/showthread...hreadid=502825