PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns

I have tried everything I can think of - is there anyway to paste cells from
one worksheet to another and not have data paste into hidden columns? ie
Pasting cells from 3 columns (A, B, C) into a worksheet where columns C and D
are hidden. The desired result is date pastes into Columns A, B, and E since
C and D are hidden. I can't find anything (like paste special) that will
alow this operation to work as described.

Yes, not sure why you are asking. I have tested this with blank worksheets
as well.

"bill k" wrote:

>
> can you insert a couple of columns in the first sheet as well and hide
> them?
>
>
> --
> bill k
>
>
> ------------------------------------------------------------------------
> bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
> View this thread: http://www.excelforum.com/showthread...hreadid=469901
>
>

Ahh - and there's the rub. I should have explained better. One worksheet
does not have hidden columns.

"bill k" wrote:

>
> if the structure of sheet1 is the same as sheet 2 the copy paste will
> work fine.
>
> you shouldn't have any data in columns c and d in sheet 1 because they
> are hidden ...........
>
>
> --
> bill k
>
>
> ------------------------------------------------------------------------
> bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
> View this thread: http://www.excelforum.com/showthread...hreadid=469901
>
>