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...
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...
What exactly doesn't work?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
I don't have excel 2007.......post an .xls
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Originally Posted by lucas
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
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln