Problem with Pasting filtered array and hidden columns

[GAJITCS]

I have an array A12:AK58 with a Defined Name "Euro_For_Export".

Rows 12:21 contain text only.

There is data in A22:AK58 in the form of a table, but not formatted as a table.

Row 22 can be considered as the header for the data below.

I have the need to hide columns R:U and some others.
I have the need to Filter the data by column A.

No problems with this.

There seems be an issue in that I am unable to select the array by name "Euro_For_Export", copy and then paste it to another worksheet without the hidden columns being copied too.
It seems that the filtering is not an issue, just the hidden columns.

Any thoughts please?

 

[GAJITCS]

I have an array A12:AK58 with a Defined Name "Euro_For_Export".

Rows 12:21 contain text only.

There is data in A22:AK58 in the form of a table, but not formatted as a table.

Row 22 can be considered as the header for the data below.

I have the need to hide columns R:U and some others.
I have the need to Filter the data by column A.

No problems with this.

There seems be an issue in that I am unable to select the array by name "Euro_For_Export", copy and then paste it to another worksheet without the hidden columns being copied too.
It seems that the filtering is not an issue, just the hidden columns.

Any thoughts please?

The answer was hidden away in the forum already.

I have replaced the VBA Copy statement with

Application.Selection.SpecialCells(xlCellTypeVisible).Copy

And it works a treat

Answer found here: https://www.mrexcel.com/forum/excel-questions/413078-dont-paste-hidden-columns.html

Thank you TheNextGuy