How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal

Hello, Folks
The following line in VB works fine, but it pastes the borders, etc...
assigned to the named EntryDate cell. Is there a way to ammend this line to
PasteSpecial (xlPasteValues) ?

Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C")

Thanks,
Randy

Hi Randy,

Try:

Range("EntryDate").Copy
shComments.Cells(iNextEmptyDateCell, "C"). _
PasteSpecial Paste:=xlValues
Application.CutCopyMode = False


---
Regards,
Norman



"RAP" <[email protected]> wrote in message
news:[email protected]...
> Hello, Folks
> The following line in VB works fine, but it pastes the borders, etc...
> assigned to the named EntryDate cell. Is there a way to ammend this line
> to
> PasteSpecial (xlPasteValues) ?
>
> Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C")
>
> Thanks,
> Randy
>
>

Thank you, Norman. It worked like a charm. It code appears obvious to me
now. I thought I had tried that, but apparently I hadn't. I appreciate it.
Randy


"Norman Jones" wrote:

> Hi Randy,
>
> Try:
>
> Range("EntryDate").Copy
> shComments.Cells(iNextEmptyDateCell, "C"). _
> PasteSpecial Paste:=xlValues
> Application.CutCopyMode = False
>
>
> ---
> Regards,
> Norman
>
>
>
> "RAP" <[email protected]> wrote in message
> news:[email protected]...
> > Hello, Folks
> > The following line in VB works fine, but it pastes the borders, etc...
> > assigned to the named EntryDate cell. Is there a way to ammend this line
> > to
> > PasteSpecial (xlPasteValues) ?
> >
> > Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C")
> >
> > Thanks,
> > Randy
> >
> >
>
>
>