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?

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?

That worked perfectly, thank you, I've been trying to figure this out for a
long time!thats great!

"Bob Phillips" wrote:

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?