Prev: Cell.Text different from Cell.Value when dates are concerned..
Next: Computer that can solve Linear Programming problem?
From: Mike H on 20 Apr 2010 10:33
> What I mean is, it is not finding the matching data in the first place

Then your data isn't a match. Check for rogue leading/trailing spaces
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Wes_A" wrote:

> 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
From: Rick Rothstein on 20 Apr 2010 10:38
Can you give us an example of data it won't find?

--
Rick (MVP - Excel)



"Wes_A" <WesA(a)discussions.microsoft.com> wrote in message
news:D947B75D-6F9A-4BE0-B8B2-2985B34254EC(a)microsoft.com...
> 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

First  |  Prev  | 
Pages: 1 2
Prev: Cell.Text different from Cell.Value when dates are concerned..
Next: Computer that can solve Linear Programming problem?