Sorting full table by name

[thorb]

hi,
i´m new to excel. i´ve created a table B16 to H25
B=name C=adr D=city E=zip ... etc.
when i insert a new name, i want to to automaticaly sort
the table by the names.
the following code only sorts B, the columns from C to H
are untouched. what is wrong ?

Please Login or Register  to view this content.

thx and regards from germany
thorsten

[marreco]

Read the rules
place the code between the tags

[marreco]

Try..

Please Login or Register  to view this content.

[thorb]

hi,
thx, but it doesn´t work. i´ve inserted the code in the editor
but it did nothing
some rows or cells can be empty

[thorb]

nobody here who could help ?

edit: problem solved :-)
the following code does it

Please Login or Register  to view this content.