Hello,

I'm trying to keep my references when I drag and drop from one cell to
another so i'm using INDIRECT("D7") for instance. Thing is i want to
drag fill the function but i want D7 to change dynamically, for
instance INDIRECT("D8") or INDIRECT("E7")

Thanks in advance. :)


--
Sophat
------------------------------------------------------------------------
Sophat's Profile: http://www.excelforum.com/member.php...o&userid=25926
View this thread: http://www.excelforum.com/showthread...hreadid=393019