s there a command that will copy the CELL from the row above it -- i.e.
copy A1 to copy A2
.. 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
cell from the row above

THANKS

Sub fill_in_the_blanks()

Application.ScreenUpdating = False
Columns("A:A").Select
For Each cell In Selection
If cell = "" Then
*copy the cell above it and paste the cell from above to here*
End If
Next cell
Application.ScreenUpdating = True

End Sub


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