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
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
[vba]
Rows(2).Resize(however_many_lines_to_insert).Insert
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber