Inserting 3 blanco rows
 

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?!

Inserting 3 blanco rows
 

As simple as

Rows("1:3").Insert

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Basta1980" wrote in message
...
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?!

Inserting 3 blanco rows
 

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 :)

"Bob Phillips" wrote:

As simple as

Rows("1:3").Insert

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Basta1980" wrote in message
...
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?!