Code wont work - help please
Can you give us an example of data it won't find?
--
Rick (MVP - Excel)
"Wes_A" wrote in message
...
What I mean is, it is not finding the matching data in the first place,
sorry
if I wasn't clear in my question.
"Wes_A" wrote:
My code:
Appears to run through but does not produced the expected result, only
offsets from current cell.
Sheets("AUDIT_TRAIL_MONTHLY").Select
On Error Resume Next
Range("A13:A24").Find(What:=Range("D2"), LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False).Offset(0, 1).Activate
|