both ideas are good,

but I've just realised I want to insert a row above when I find a valu
in the column (and copy to the row above). Although generally the sam
formulas will work, it throws off the formula, as once the row i
inserted it changes the selected cell.

how would you modify the existing formula to account for this?

Thanks for your help!

Armaga

--
armaga
-----------------------------------------------------------------------
armagan's Profile: http://www.excelforum.com/member.php...fo&userid=3423
View this thread: http://www.excelforum.com/showthread.php?threadid=54544