Range of Cells
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? |
Range of Cells
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? |
Range of Cells
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? |
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com