Do you use VBA?

If you do, take a look at VBA's help for .printarea. You'll see that it's a
string. So behind the scenes, excel is storing that as the address--not the
range (or named range).

So it's not as surprising as it would seem at first blush.

stevepain wrote:

Thanks Dave, that seems to work.
Strange characteristic that the print area reverts back to the cell
references in the first place - but I guess that's one of the quirks
that has been sent to challenge us!

--
stevepain
------------------------------------------------------------------------
stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759
View this thread: http://www.excelforum.com/showthread...hreadid=388412

--

Dave Peterson