Good point... Thanks Tom. I always just use the range object as the argument
of the copy function. Like I have always said... You don't miss much...

Sheet1.Range("A1:A10").Copy Sheet2.Range("B1")

or in this case

Range("XXX").Copy Worksheets("County
Records").Range("a5").End(xlDown).Offset(2, 0)

Thanks...

"Tom Ogilvy" wrote:

Actually, a range doesn't have a paste method. So if you want this format
you need:

Worksheets("County Records").Range("a5").End( _
xlDown).Offset(2, 0).Pastespecial xlPasteAll

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
xlDown is an argument of the .end property. This should work

Worksheets("County Records").Range("a5").End(xlDown).Offset(2, 0).Paste

HTH

"davegb" wrote:

I'm trying to paste some text from one worksheet to another, but I keep
getting the error "Object doesn't support this property or method". I
checked in the object browser and it shows range, offset and paste as
belonging to worksheets.
I'm trying to paste the contents of the clipboard into cells starting 2
rows below the last cell with data in column a on the "County Records"
worksheet.

Worksheets("County Records").Range("a5").xlDown.Offset(2, 0).Paste

I know some of you will spot this in a second. Please let me know what
I'm doing wrong, and why this doesn't work even though the object
browser tells me they all "fit".
Thanks in advance.