If the Peter is me rather than Peter (VoG) then you could try something like thisThanks you gentlemen!
I haven't tried them yet, but Peter, suppose I wanted to do some error checking. I do not want to paste a value, or range of values, into the next available cell and exceed the 25 cell available "zone". Is there a way I can extract a value from your suggestion? ie a way to set value to where that formula is going to drop the value(s).
Jenn
Dim lNextRw As Long
lNextRw = Range("A" & Rows.Count).End(xlUp).Row + 1
If lNextRw < 26 Then
YourRange.Copy Destination:=Range("A" & lNextRw)
Else
MsgBox "Row 25 already used"
End If