Specification said:

it will copy 9 colums to the right and 4 rows below it

Didn't say to copy the row with Jellybeans. Unfortunately mindreading is
not a strength. <g

so you don't need Offset(0,0). That does nothing.

--
Regards,
Tom Ogilvy


"duncan_J" wrote in message
...
Thanks Tom,
You put me on the right track... This what worked.
Range("A:A").Find("Jellybeans").Offset(0, 0).Resize(5, 14).Copy _
Destination:=Worksheets("Sheet2").Range("A1")