Hi Jim,

When I tried renaming the sheet, it didn't show the behaviour you
mentioned in your post. The formula accomodated it without any
problem.

Mangesh



But not so, if renamed sheet 20 is moved to the end
(right-most-position),
meaning outside the internal index numbering scheme initially
established.
HTH



--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381871