Hi,
I have checked the site:
http://j-walk.com/ss/excel/tips/tip44.htm

but the difference with my problem is that I dont have a user form. I
just have an excel sheet with some command buttons on it. When you
click any command button, I want the name of the caption on that
command button to be selected so that i can sort data in another sheet
using that caption.

I know i should be able to modify the above code somehow, but don't
know what to put instead of "For Each ctl In UserForm1.Controls". I
want this to be a very basic and quick thing. If I wanted to be fancy
(which I don't) I would just create an access database.

Thanks
Kate