In L1 type =A1, then copy down column L. You will have to copy enough
formulas in column L to accomodate the size of your named range.


"paris3" wrote:


Thanks.. but... (and I don't mean to be an ingrate)...

The solution has to be code-free, relying only on formulas. This is a
for a variety of reasons.


--
paris3
------------------------------------------------------------------------
paris3's Profile: http://www.excelforum.com/member.php...fo&userid=3542
View this thread: http://www.excelforum.com/showthread...hreadid=381412