Autofilter based on user inputbox
 

Hey Garry. Thanks for the response. The code executed properly, but with the same result - the hidden columns were not copied over.

Autofilter based on user inputbox
 

on 5/10/2011, Steve supposed :
Hey Garry. Thanks for the response. The code executed properly, but with
the same result - the hidden columns were not copied over.

I guess you'll have to unhide those columns beforehand, then hide them
again. In this case I'd stick with the original code (no wks.Active, no
..Select, no Selection.Copy) and do unhide before and hide after the
copy code.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc