Discussion Locked

vb- insert row auto after sotring

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to insert row automatically, after sorting A to Z in excel, in alphabetical order.
example: if i have at cell B2 the name "Bush"
and at cell B3 the name "Clinton".
I would like that automatically the macro will add a row between them.
so "Bush" will still be at cell B2, but "Clinton"
will change into cell B4!
and an empty row will add into row B3!!!
thank you in advance-
Assaf.

1 reply

by bristar

Which program are you referring to? If this is really in VB, then are you referring to a list box? Text Box? ADODB dataset?

This discussion is closed to new replies.