copy and paste

[Jack]

I want to copy a date from a cell and paste it to a cell in another worksheet
in the same workbook. i am selecting the cells ok but the copy and paste
operation do not seem to work. can anyone help
ActiveSheet.Select
Cells(z, 6).Copy
Sheets("approvals").Select
ActiveSheet.Select
Cells(y, 5).Select
Paste Cells(y, 5)
--
Jack

[Don Guillett]

try
Cells(z, 6).Copy Sheets("approvals").Cells(y, 5)
or, for values only
Sheets("approvals").Cells(y, 5).value=Cells(z, 6)

--
Don Guillett
SalesAid Software
[email protected]
"Jack" <[email protected]> wrote in message
news:[email protected]...
>I want to copy a date from a cell and paste it to a cell in another
>worksheet
> in the same workbook. i am selecting the cells ok but the copy and
> paste
> operation do not seem to work. can anyone help
> ActiveSheet.Select
> Cells(z, 6).Copy
> Sheets("approvals").Select
> ActiveSheet.Select
> Cells(y, 5).Select
> Paste Cells(y, 5)
> --
> Jack

[Jack]

Don
that did not help although I did not say that the cell I want to copy gets
it's date from a formula like = B34 +14 , thus it is just a snapshot of the
value in the cell that I want, sorry
--
Jack

"Don Guillett" wrote:

> try
> Cells(z, 6).Copy Sheets("approvals").Cells(y, 5)
> or, for values only
> Sheets("approvals").Cells(y, 5).value=Cells(z, 6)
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Jack" <[email protected]> wrote in message
> news:[email protected]...
> >I want to copy a date from a cell and paste it to a cell in another
> >worksheet
> > in the same workbook. i am selecting the cells ok but the copy and
> > paste
> > operation do not seem to work. can anyone help
> > ActiveSheet.Select
> > Cells(z, 6).Copy
> > Sheets("approvals").Select
> > ActiveSheet.Select
> > Cells(y, 5).Select
> > Paste Cells(y, 5)
> > --
> > Jack
>
>
>

[Don Guillett]

As I said, if you just want the VALUE use the 2nd formula.

--
Don Guillett
SalesAid Software
[email protected]
"Jack" <[email protected]> wrote in message
news:[email protected]...
> Don
> that did not help although I did not say that the cell I want to copy gets
> it's date from a formula like = B34 +14 , thus it is just a snapshot of
> the
> value in the cell that I want, sorry
> --
> Jack
>
> "Don Guillett" wrote:
>
>> try
>> Cells(z, 6).Copy Sheets("approvals").Cells(y, 5)
>> or, for values only
>> Sheets("approvals").Cells(y, 5).value=Cells(z, 6)
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Jack" <[email protected]> wrote in message
>> news:[email protected]...
>> >I want to copy a date from a cell and paste it to a cell in another
>> >worksheet
>> > in the same workbook. i am selecting the cells ok but the copy and
>> > paste
>> > operation do not seem to work. can anyone help
>> > ActiveSheet.Select
>> > Cells(z, 6).Copy
>> > Sheets("approvals").Select
>> > ActiveSheet.Select
>> > Cells(y, 5).Select
>> > Paste Cells(y, 5)
>> > --
>> > Jack
>>
>>
>>