ExcelBanter - insert row below activecell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - insert row below activecell (https://www.excelbanter.com/excel-programming/282496-insert-row-below-activecell.html)

ljb[_2_]

insert row below activecell

I have

ActiveCell.EntireRow.Insert

But I really want the row inserted below the active cell's row. How to do?

thanks
LJB

Ron de Bruin

insert row below activecell

Try this

ActiveCell.Offset(1).EntireRow.Insert

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"ljb" <. wrote in message ...
I have

ActiveCell.EntireRow.Insert

But I really want the row inserted below the active cell's row. How to do?

thanks
LJB

ljb[_2_]

insert row below activecell

thank you
LJB

All times are GMT +1. The time now is 08:24 AM.