Sort Button In Excel

**ddkk28** · 04-21-2011, 05:05 AM

Dear Respected Members,

Please someone help me to write a Macro button to sort the coloum (A-Z), I tried my best but it is not working (please bear with me Iam new to Macro).

Appreciate your advice or help (see attached file) I need similar button for each column.

Thanks in advance
David

**ddkk28** · 04-22-2011, 10:52 AM

Dear members pls someone help - thanks

**Krishnakumar** · 04-22-2011, 11:31 AM

Hi,

PFA. Just select any of the cells and click the button.

Kris

**realniceguy5000** · 04-22-2011, 04:45 PM

Originally Posted by ddkk28

Dear members pls someone help - thanks

Ok, as you requested a sort button on every column. This should do that for you.

Couple things you will need to do before the script works is.
Hit ALT +F11

From VBA Menu :
'Tools>References. Put a check mark in the below fields. You may need to scroll to find them.

Microsoft Visual Basic For Applications Extensibility
And
MS VBA Extensibility 5.3 Library

You should get a good idea how it works.

Thank You, Mike

**ddkk28** · 04-23-2011, 06:38 AM

Dear Krishnakumar & Mike,
Thank you so much for solve my problem - excatly the same I need Appreciate your efforts in teaching and helping beginers in Excel - thanks again guys.
David