Can pasting ignore hidden columns?

[Astralogic]

Hi, if I copy a number of horizontal cells and paste them over hidden columns, the data goes into the hidden columns. Is there a way to to paste the data onto the spreadsheet and have it ignore the hidden cells.

Just in case I didn't explain that clearly I'll give an example, if I copy ten horizontal cells and paste it at A1 while having column B hidden, I will see only 9 cells pasted in, since the second one is hidden. I want to paste it and have the visible ten cells filled with the data.

Any help appreciated.
Thanks

[Richard Buttrey]

Do you mean you want to copy say A1:J1 from one sheet and paste to another sheet where column B is hidden so that A1 goes to A1, and B1:J1 goes to C1:K1 ?

[JLGWhiz]

Basically the answer is no. If copy a horizontal range of six columns and paste it to range with a hidden column, you will see only five columns of data in the destination range.

[6StringJazzer]

I believe that Richard has correctly paraphrased your question and I also believe this would require a macro.

[Richard Buttrey]

Basically the answer is no. If copy a horizontal range of six columns and paste it to range with a hidden column, you will see only five columns of data in the destination range.

Yes indeed. That's what happens now. Is that statement of yours a confirmation of that and you want something else to happen? If so what?.

My post #2 was seeking to establish what you wanted to see. I'd assumed copying 10 columns but since you're using 6 in your latest post let's put the question again.

If the numbers 1 to 6 are in A1:F1 and you copy them to A1 in a another sheet where column B is hidden, do you want to see numbe 1 in A1 and numbers 2 to 6 in C1:G1?

[Astralogic]

Yes indeed. That's what happens now. Is that statement of yours a confirmation of that and you want something else to happen? If so what?.

My post #2 was seeking to establish what you wanted to see. I'd assumed copying 10 columns but since you're using 6 in your latest post let's put the question again.

If the numbers 1 to 6 are in A1:F1 and you copy them to A1 in a another sheet where column B is hidden, do you want to see numbe 1 in A1 and numbers 2 to 6 in C1:G1?

Hi Richard, you're first post described exactly what I want to do as well as the last line of the quote above, to simply paste a row of cells into the cells that are visible, but I think you may have confused JLGWhiz for me.

But yes, you are understanding my problem correctly.

[Richard Buttrey]

In that case you'll need a macro

One way would be for the macro to copy the data and paste it to A1, then identify which of the columns it's been posted two are hidden and then copy and paste the hidden column and cells to the right pasting that copied range offset one column to the right.

The other way if the hidden column is known in advance would be to temprarily insert a blank column in the original data where the hidden column is located in the paste range, and copy the 7 cells to A1. Then delete the temporary column.