Solved: Insert column then autofilter data

[tengkurap]

Please someone help me with this worksheet
I want to insert one column from left (A Column)
But when i insert one column the macro can't execute
what can i do am newbie please someone fix for me
thank...

[Bob Phillips]

What exactly doesn't work?

[tengkurap]

open the attached file choose sheet "Data with Autofilter" not "Data at List" and try to insert 1 column from left column A and then run the code
it show "Auto filter method of range class failed"
Can you fix for me please
thank for quick reply

[lucas]

I don't have excel 2007.......post an .xls

[tengkurap]

I don't have excel 2007.......post an .xls


here the xls sample
please i want insert 1 column from left (Column A)
but when i insert the macro cant run
u can try and u will see the problem
anyway thank for reply

[lucas]

set the switch to off

insert your column to the left of the others.
add your data to column 1


notice the autofilter arrows do not show in column A

select the column letters from A to H (the new area) so you have all the rows selected along with the columns.......

now go to data-filter-and click on the autofilter selection.....

that removes all arrows. Now do it again and all columns will have arrows and it will now work as required.