If statement comparing strings

[jhogie]

I've been working on this one for a while and quite seem to get it.

I have a sheet ('SheetName') full 'i' number of Tag #s in Column 'A'. The Tag #s are either L-##### or LL-##### (where L/LL are specific combinations of Letters)

I am wanting to enter the 'If Statement' if the Tag #s appear in any of the other sheets ('j' number of sheets)(in B-columns with 'k' number of rows). BUT in the other sheets there may be additional characters appearing after the Tag #. I need to enter the 'If Statment' even if this occurs.

Here is the most recent If statement that I've tried... I just need to figure out what to write after 'Like'.

If wkb.Worksheets(SheetName).Range("A" & i) Like (Left(wkb.Worksheets(j).Range("B" & k), 8) Or (Left(wkb.Worksheets(j).Range("B" & k), 7))) Then

Any help/suggestions would be greatly appreciated,
Thanks in advance.

-Hogie

 

[SkipVought]

Hi,

You're close...

If CStr(wkb.Worksheets(SheetName).Range("A" & i)) Like "'*" & (RIGHT(wkb.Worksheets(j).Range("B" & k), 5) & "*'" Then

I assume that Column A has these 5-digit numbers


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jhogie]

Thanks Skip for the quick reply, but I don't think I explained my issue well enough so your code doesn't fully address work.

However, I actually figured out a different (longer) way of doing it, and it is posted below (for anybody to look at).

Here I am determining the length of the Tag# and then dealing with it as two different casess; weather it has 7 or 8 characters, and just comparing the first 7/8 characters of the tag#s on all the other sheets.

If Len(wkb.Worksheets(SheetName).Range("A" & i)) = 7 Then
  If wkb.Worksheets(SheetName).Range("A" & i) Like (Left_(wkb.Worksheets(j).Range("B" & k), 7)) Then
    CopyCount = CopyCount + 1
  End If
ElseIf Len(wkb.Worksheets(SheetName).Range("A" & i)) = 8_ Then
  If wkb.Worksheets(SheetName).Range("A" & i) Like (Left_(wkb.Worksheets(j).Range("B" & k), 8)) Then
    CopyCount = CopyCount + 1
  End If
End If

- Thanks again
Hogie

 

[SkipVought]

The Like operator my be used like...

If expression1 Like "somevalue[red]*[/red]" then

or

If expression1 Like "[red]*[/red]somevalue" then

or

If expression1 Like "[red]*[/red]somevalue[red]*[/red]" then

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}