INSERT A ROW AFTER EVERY 5 CELLS IN A SHEET THAT HAS DATA OF 120

[Guest]

I want to insert rows after every 5 cells in a excel file that has data of
120 rows. I don’t want to start inserting every single time. Is there a
function to insert a rows in a file at an interval?

 

[Chip Pearson]

Try

Dim RowNdx As Long
For RowNdx = 1 To 200 Step 6
Rows(RowNdx).Insert
Next RowNdx



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Hi JVR,

Go to http://www.andrewsexceltips.com/my_utilities.htm and download the
utillities. I got this tip this week from this discussion group and it is
very helpful and it is free! When it is installed on your computer, just go
to the Andrew's Utilities tool bar, then to the "sheet utilities" and select
"show selection tools". There are many functions that can do the work! and
much more.

JS

 

[Guest]

Where do I write this code?

JS

Try

Dim RowNdx As Long
For RowNdx = 1 To 200 Step 6
Rows(RowNdx).Insert
Next RowNdx



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com