ExcelBanter - Inserting blank rows

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

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

- - Inserting blank rows (https://www.excelbanter.com/excel-programming/285567-inserting-blank-rows.html)

ChuckM[_2_]

Inserting blank rows

How do insert 2 blank rows above row n. n is an integer

thanks
chuck

Dave Peterson[_3_]

Inserting blank rows

Dim n As Long
n = 5
Rows(n).Resize(2).Insert

ChuckM wrote:

How do insert 2 blank rows above row n. n is an integer

thanks
chuck

--

Dave Peterson

All times are GMT +1. The time now is 09:43 PM.