This will work

=MAX(INDIRECT(CONCATENATE("D1:D",COUNTA(B1:B1000)) ))

unless you have blank cells in column D

More info here

http://www.grbps.com/Excel7.pdf


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=563195