PDA

View Full Version : Macro inserting rows between two columns containin a specifict text



buhay
09-26-2010, 02:36 PM
I am looking for a macro that inserts rows between two columns containin a specifict text.

For example:

--------ColA

row1---CTB

row2---BTC

The macro should insert rows between CTB and BTC

Thanks in advance

Bob Phillips
09-26-2010, 04:24 PM
Rows(2).Resize(however_many_lines_to_insert).Insert