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!