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