With ActiveCell

.EntireRow.Copy .Offset(-1, 1 - .Column)
End With


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"OrlaLynch" wrote in message
...
I have a macro adding a row. I need to copy this to the row above it. My
problem is I don't know how to refer to the row above it when it will
change
row number all the time as rows will be added constantly.How would I do
this?