Keep Destination Format

S

SteveT

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
 
B

Billy Liddel

Steve

Try something like this

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

Peter
 
S

SteveT

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
 
Top