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?
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?