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