Hi,

Can you please guide me how to create an empty rows (by using macros)
in a spread sheet contains 300 rows of data?

Thanks

Renga

On row in one place?

Rows(200).Insert

Many rows in one place?

Rows(200).Resize(10).Insert

One row in many places?

For i = 1 To 300 Step 20
Rows(i).Insert)
Next i

Many rows in many places?

For i = 1 To 300 Step 20
Rows(i).Resize(5).Insert)
Next i

--
HTH

Bob

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

"lbrrenga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Can you please guide me how to create an empty rows (by using macros)
> in a spread sheet contains 300 rows of data?
>
> Thanks
>
> Renga
>

Typo alert.

Don't include the closing paren ")" after the .insert

Bob Phillips wrote:
>
> On row in one place?
>
> Rows(200).Insert
>
> Many rows in one place?
>
> Rows(200).Resize(10).Insert
>
> One row in many places?
>
> For i = 1 To 300 Step 20
> Rows(i).Insert)
> Next i
>
> Many rows in many places?
>
> For i = 1 To 300 Step 20
> Rows(i).Resize(5).Insert)
> Next i
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "lbrrenga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > Can you please guide me how to create an empty rows (by using macros)
> > in a spread sheet contains 300 rows of data?
> >
> > Thanks
> >
> > Renga
> >

--

Dave Peterson