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