"davegb" wrote in message
oups.com...
Bob,
My code was:

ActiveSheet.ShowAllData

I just recorded it. I tried yours, and if fixed the problem. Thanks! I
tried it with column a instead of h, and i worked fine. Does it matter
at all what column you use?

Only insofar as it must refer to the column that you have set Autofilter on.