Inserting rows with a macro


Posted by Butch on May 16, 2001 8:59 AM

I have a column of text entries. If an entry is different from the entry in the row directly above it, I want to insert two rows. I want to continue down the column doing this until I run out of entries. Here is an example:
a
a
a
b
b
b
c
c
c
should be:
a
a

b
b

c
c

Any suggestions?



Posted by Barrie Davidson on May 16, 2001 9:25 AM

Have a look at
13820.html
and the reponses.