Search a Row starting at Specified Column

[cart0250]

Hello,

Below searches row 1 for value corresponding to the testData variable.

How could i adapt this to search row 1 beginning at column F (rather than col A)?

I'd like to continue using Find rather than a loop.

Set d = Sheets("Testing").Rows(1).Find(What:=testData, LookAt:=xlWhole)

Much appreciated.

 

[PeteWright]

Set d = Sheets("Testing").Range("F1").Find(What:=testData, LookAt:=xlWhole)

Does the above work?

 

[Alex Blakenburg]

Try:

    With Sheets("Testing")
        Set d = .Range("F1", .Cells(1, Columns.Count)).Find(What:=testData, LookAt:=xlWhole)
    End With

Pete's version only looks in F1

 

[Peter_SSs]

The fact that this question has been asks implies that testData might occur more than once in row 1. In case there might possibly be more than one instance in F1 and right, I would suggest a further slight change assuming that you want to be sure to find the first occurrence in the target range.

With Sheets("Testing")
  Set d = .Range("F1", .Cells(1, Columns.Count)).Find(What:=testData, After:=.Cells(1, Columns.Count), LookAt:=xlWhole, SearchDirection:=xlNext)
End With