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

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


Rows(ActiveCell.Row - 1).Copy Rows(ActiveCell.Row)



the Copy comman has an optional destination parameter.

The code above copies the row one above, to the current row.

Hi

This can be done without a loop. Hope this helps.


Sub fill_in_the_blanks()


Application.ScreenUpdating = False
Columns("A:A").Select
'*copy the cell above it and paste the cell from above to here*
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[-1]C"

Application.ScreenUpdating = True

End Sub



narutard wrote:
is there a command that will copy the row from the row above it. I'm
thinking of selection.filldown but i don't know how to adjust the
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 a
series of rows and if there is a certain criteria i want it to copy the
above row

THANKS


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=466376

thanks al

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