Column reference

[Fish]

Group,

I am stuck within a part of my code that looks at a
static row but a dynamic Column. I am trying to make it so
each time the macro runs it looks for that cell reference
in a loop which is always located on persay the 5th row
but column always changing. Anybody have any ideas to do
this?

Thanks in advance,

Fish

 

[Tom Ogilvy]

set rng = cells(5,256).End(xltoLeft)
rng.Select

or

for each cell in Range(cells(5,1),Cells(5,256).End(xltoLeft))
if cell.Value = "testString" then
cell.Select
exit for
end if
Next

or

set rng = Range(cells(5,1),Cells(5,256).End(xltoLeft))
set cell = rng.find("TestString")
if not cell is nothing then
cell.Select
End if