Range of Cells

[OrlaLynch]

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?

 

[Bob Phillips]

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]

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