How to use autofilter in vbscript

Hello All
I am stuck with my code. I am trying to auto-filter a worksheet on certain criteria(i.e. "desktop", "notebook", "tablet") - and get the output as you would get using filter in the excel sheet. And trying to delete all the columns in the excel sheet except two of them based on their column header (for example: if the column headers are "serial number" and "product id" I would like to delete all the columns except the two columns which has these column headers). Here is me code, could you please check the code and I appreciate if any one can guide me.

Please Login or Register  to view this content.

The above code is not working!!!!!!!!
Thankx
Rashme

Welcome to the forum.

Please take a few minutes to read the forum rules, correct your code tags, and change the title of your thread to describe your problem.

Thanks.