Hi all,

I am trying to define a range but the range needs to be dynamic.
Instead of simply defining the range as (A1:A15) I need to express my
range as (A1: "A1+the value in another cell, A20).

Please could you let me know how to achieve this.
Thanks!
Jag


--
jagbabbra
------------------------------------------------------------------------
jagbabbra's Profile: http://www.excelforum.com/member.php...o&userid=32525
View this thread: http://www.excelforum.com/showthread...hreadid=548517