Inserting 3 blanco rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Basta1980 - 19 May 2008 07:35 GMT

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

Reply to this Message

Bob Phillips - 19 May 2008 09:01 GMT

As simple as

Rows("1:3").Insert

Signature

---
HTH

Bob

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

> Hi,
>
[quoted text clipped - 4 lines]
> code
> for that?!

Reply to this Message

PaulW - 19 May 2008 11:56 GMT

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

> As simple as
>
[quoted text clipped - 8 lines]
> > code
> > for that?!

Reply to this Message