Pasting to Multiple Selections.

Is there any way you can copy from a contiguous range and paste it to
multiple cells or range that are non contiguous i.e. multiple columns of a
different worksheet? Further can you tell excel not to copy data to hidden
columns?

On Sat 01/07/06 10:11:01, JayQue <JayQue@discussions.microsoft.com> wrote:
> Is there any way you can copy from a contiguous range and paste it to
> multiple cells or range that are non contiguous i.e. multiple columns of a
> different worksheet? Further can you tell excel not to copy data to hidden
> columns?

I do not think you can copy to non continuous cells or columns. Excel
copies the sections and paste the same sequence of cells or columns. The
hidden columns are still part of the sequence therefore it will paste to
those hidden columns.