Finding the address of the next instance of a string within row by searching in left direction

[rubberband0]

Hi,

Suppose I have the string "01/2012" as the value of cell AT7. How could I use vba to find the next cell address that contains this specific string value? I want to start at cell AT7 and search along the 7th row in the leftward direction.

Thanks!

 

[Trevor G]

Try recording a macro and use the find option, as below:

Sub Macro1()
'
' Macro1 Macro
'

'
Cells.Find(What:="01/2012", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Cells.FindNext(After:=ActiveCell).Activate
End Sub