Macro to Sort column B and C alphabetically

[anthony.maddick]

Hello i have a members list with with cell be containing members name (starting in B3) in the following format (lastname, firstname) then in Column C i have the members location. i have made a VBA that sorts the lists but it doesnt keep the members location and name together!
i want it to auto soft the names alphabetically but keep their location beside it in column C

Please Login or Register  to view this content.

this is the code i am using, Can anyone tell me where i have gone wrong?
regards
Anthony

[alansidman]

Your range(x,y).sort only takes into account the target column. Your range needs to be expanded to include the non-target ranges.

[anthony.maddick]

Hi Alansidman,
i understand what you mean but unsure how to put it into code! sorry im new to VBA

[anthony.maddick]

i recorded this one and it works as a button but when i put it into the worksheet code it does not auto work.

Please Login or Register  to view this content.

[anthony.maddick]

this code works however its not automatically doing it if i make a button it works

Please Login or Register  to view this content.