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" wrote in message
oups.com...
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" wrote in message
oups.com...
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