Copy Cell from Row Above

[narutard]

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

[Mike Punko]

Why not just use teh IF Function?

A3=IF(A2>0,A2,A1)

A2>0 This is you rule for a True or False
A2 Is returned if True
A1 Is returned if False

A B
1 1 2
2 0 2
3 1



"narutard" wrote:

>
> 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
>
>