Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pattern Matching with cells function
Hi all, I looked for an answer to this one but can't find it. Your
help is always appreciated. ------------------------- dim bottom as long bottom = Cells(Rows.count, "B").End(xlUp).Row For a = bottom To 3 Step -1 If Cells(a, 4) = "*Abstractor" Then Cells(a - 1, 10) = Cells(a, 7) Cells(a - 1, 11) = Cells(a, 8) End If Next a -------------------------- It seems to me that the * character is not acting like a wild card for me. What is the proper way to look through the cells and try to match a pattern? Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pattern Matching with cells function
John,
Use the LIKE operator. E.g, If Cells(a,4) Like "*Abstractor" Then -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John" wrote in message m... Hi all, I looked for an answer to this one but can't find it. Your help is always appreciated. ------------------------- dim bottom as long bottom = Cells(Rows.count, "B").End(xlUp).Row For a = bottom To 3 Step -1 If Cells(a, 4) = "*Abstractor" Then Cells(a - 1, 10) = Cells(a, 7) Cells(a - 1, 11) = Cells(a, 8) End If Next a -------------------------- It seems to me that the * character is not acting like a wild card for me. What is the proper way to look through the cells and try to match a pattern? Thanks John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pattern Matching with cells function
note that LIKE is case sensitive
(unless OPTION COMPARE TEXT has been set in the module's decl. section) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Chip Pearson" wrote: John, Use the LIKE operator. E.g, If Cells(a,4) Like "*Abstractor" Then |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to Produce a Number Pattern? | Excel Worksheet Functions | |||
Pattern Matching | Excel Discussion (Misc queries) | |||
Matching and Aligning Cells Formula/Function? Macro? | Excel Worksheet Functions | |||
pattern matching possible? | Excel Worksheet Functions | |||
Wildcard pattern matching and replace in string | Excel Programming |