CREATE AN EMPTY ROWS
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
|