is there a command that will copy the row from the row above it. I'
thinking of selection.filldown but i don't know how to adjust th
fields so that it only looks 1 row above it

i'm planing on using this in a loop for a selection that will scan
series of rows and if there is a certain criteria i want it to copy th
above row

THANK

--
narutar
-----------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...fo&userid=2511
View this thread: http://www.excelforum.com/showthread.php?threadid=46637