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