IF? you mean that you want to filter the range by the selected column then
you would probably want a double_click event macro to do the autofilter

--
Don Guillett
SalesAid Software

<Nasir Naqvi wrote in message ...
Hi,

How can we creat separate button in MS excel for selected range class in
auto filter. If we click on button then only selected range class appears.
Should we write script on Macro in VB.

For example,

Button Name "XYZ"

Column A (with Auto Filter)
ABC
XYZ
DEF
XYZ

If we click on button "XYZ" then cell "XYZ" instead of "ABC" & "DEF".

Regards

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com