hi
i doubt that you can. technically excels "filters" by hiding rows. and it's
not possible to hide or unhide part of a row (or column).

Regards
FSt1

"peyman" wrote:

hi,
How can I limit this code Worksheets("sheet 1").ShowAllData to some specific
columns like B & C istead of unfiltering whole the worksheet.
Thanx,