Steve formulated on Tuesday :
Hey Garry,

I stepped through the code, and the issue is the Copy. When you select Copy
while the data is in Autofilter, the hidden columns are not selected in the
copy range.

I did a search on the newsgroup to look for code that can identify hidden
columns prior to the code run, unhide them, and then rehide the same columns
after code execution...couldn't find anything yet.

Anyway, thanks for your help!

Steve,
I answered in your other thread. You are aware that however you
interact with this NG that you're creating new threads for the same
topic instead of replying to existing threads for that topic, right?
Makes it hard to follow...

--
Garry

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