CREATE AN EMPTY ROWS

[lbrrenga]

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

 

[Bob Phillips]

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)

 

[Dave Peterson]

Typo alert.

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