Find text in document and copy that text only

[Glasgowsmile]

Hello,

I have the following VBA

         Set Fnd = Range("A:A").Find("name id:", , , xlPart, , , False, , False)

and I want to copy that name id information and currently, I'm trying this but it's not working - what am I missing here?

Range(Fnd.Offset(1)).Copy Sheet2.Range("A1")

I also tried this but I don't know for sure that the data is going to land in A10 each time.

  Range(Fnd.Offset(1), Range("A10")).Copy Sheet2.Range("A1")

 

[BSALV]

Fnd is already a range, was that find succesfull ?
if not Fnd is nothing then Fnd.Offset(1).Copy Sheet2.Range("A1")
Range(

 

[Glasgowsmile]

Fnd is already a range
Fnd.Offset(1).Copy Sheet2.Range("A1")

I see and I changed the (1) to a (0) and it pulled exactly what I needed. Thanks!

 

[BSALV]

     Set fnd = Range("A:A").Find("name id:", , , xlPart, , , False, , False)
     fnd.Offset(1).Copy sheet2.Range("A1")
     Set fnd2 = Range(fnd.Offset(1), Range("A10"))
     fnd2.Copy sheets2.Range("A1")