without
defining the full paste-to range?

No.

Plus assigning a value isn't really pasting (at least I wouldn't call it
such - for what that is worth <g)

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:%Zz2f.5422$nz.3648@trnddc03...
Thanks in advance for any help

Usually I like to use something like

Paste multi-cell range to a single cell (similar to paste All)
Sheets(1).Rng1.copy _
Detination:Sheets(2).Range("A1")

or

Paste multi-cell range to an identically sized range (similar to paste
value)
Sheets(2).Rng2.Value = Sheets(1).Rng1.Value

Is there a way to amend the first code into a paste value version, without
defining the full paste-to range?

Thanks...

--
steveB

Remove "AYN" from email to respond