Macro for inserting a rows

[maddockd]

I have a long list of unique cells and i'm looking for a way to insert 7-8 rows between each unique cell. any macros available that can accomplish this for me?

Thanks,
Dan

[cytop]

Answer as sparse as the question

Please Login or Register  to view this content.

Replace 8 in

Please Login or Register  to view this content.

with the row number of the 2nd last row...

Replace 8 in

Please Login or Register  to view this content.

with the number of rows to insert.

[davsth]

if the values are in column A

Please Login or Register  to view this content.

[maddockd]

Say I use this script and I take the following list:
a
b
c

and turn it into:
a


b


c

How can I make it so that the rows I've inserted are the same as the unique above? meaning this:

a
a
a
a
a
b
b
b
b
b
c
c
c
c
c

[davsth]

Please Login or Register  to view this content.

[maddockd]

Please Login or Register  to view this content.

When I use this script it duplicates only the first value and goes down the full column with that 1 duplicate