Inserting 3 blanco rows

  • Thread starter Thread starter Basta1980
  • Start date Start date
B

Basta1980

Hi,

I have a sheet with data. Based on a selection i want to insert 3 blanco
rows on top of the already existing information. So normally I have row 1 to
xxx filled, and I now need 3 blanco rows to insert from row 1 to 3. Any code
for that?!
 
As simple as

Rows("1:3").Insert

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Its also the sort of thing you can use the Macro Recorder for. Although the
code will probably be 10 lines long instead of 1, it can give you an idea how
it works :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF 0 then blanco 1
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 2
Insert rows in grouped sheets 2
insert 3 rows between data 3
Mid column sum formulas with varied ranges to sum 17
Changes in How Code Acts After Upgrade of Excel 2
Marco to insert rows 2

Back
Top