ym4life Wrote:
Thanks a lot for the suggestion, I tried it and every imaginable
combination of formulas using INDIRECT, but i keep on getting Value and
Ref errors.... i'll keep on trying and any advice is much welcomed

Hmmm...that's strange...it works for me. If you'd like, I can send you
a sample file.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=383345