Range("C:C").Find("FPYR").Offset(0, -2).Resize(20, 11).Copy _
Destination:=ActiveSheet.Range("A215")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Duncan J" wrote in message
...
Range("C:C").Find("FPYR").Offset(0, 0).Resize(20, 9).Copy _
Destination:=ActiveSheet.Range("A215")
Since the only unugie name I have in this row FPYR I'm finding that name.
However, I want it to copy the 2 coulmns to the left as well as the coulmns
to the right. Running this macro the FPYR is in A215 I need it to be in C215
and the data that was in Column A B to be to be in A215 B215..
Thanks,
Dj
I posted this about an hour ago and it hasn't shown up so I'm posting
again.