Keep Destination Format
 

Hello Wise ones,

I have multi-user workbook in which one sheet has ref #
that user can past in 2nd sheet to pull various lookup data from 3rd hidden
sheet.

it is mostly cosmetic ( pet peeve ) that user doesn't past values only.

is there a macro / way to only paste values and keep dest format in
destination cell?

border / font / color all being effected.

thanks , Steven - Dallas

Keep Destination Format
 

Steve

Try something like this

mydate.Copy
Range(Cells(36, 3), Cells(nr - 9 + 36, 3)).PasteSpecial
xlPasteValuesAndNumberFormats

Peter

"SteveT" wrote:

Hello Wise ones,

I have multi-user workbook in which one sheet has ref #
that user can past in 2nd sheet to pull various lookup data from 3rd hidden
sheet.

it is mostly cosmetic ( pet peeve ) that user doesn't past values only.

is there a macro / way to only paste values and keep dest format in
destination cell?

border / font / color all being effected.

thanks , Steven - Dallas

Keep Destination Format
 

Billy, thanks for response but I'm looking for solution to keep destination
format when action taken by user.

The paste action automatically default to paste.value regardless what chosen
by user ( in this specific destionation cell ). BR, Steven



"Billy Liddel" wrote:

Steve

Try something like this

mydate.Copy
Range(Cells(36, 3), Cells(nr - 9 + 36, 3)).PasteSpecial
xlPasteValuesAndNumberFormats

Peter

"SteveT" wrote:

Hello Wise ones,

I have multi-user workbook in which one sheet has ref #
that user can past in 2nd sheet to pull various lookup data from 3rd hidden
sheet.

it is mostly cosmetic ( pet peeve ) that user doesn't past values only.

is there a macro / way to only paste values and keep dest format in
destination cell?

border / font / color all being effected.

thanks , Steven - Dallas