Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells using wildcards
Hello,
I am trying to search for partial strings in a cell, Sub Button1_Click() Dim r As Range Dim c As Range Dim st As String Set r = Range("A1", Range("A65536").End(xlUp)) st = InputBox("Enter Partial to Search", "Search By Address") For Each c In r.Cells If c = "*" & st & "*" Then '----The problem---- MsgBox c.Address End If Next c End Sub But do not know how to get the wildcard to work |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells using wildcards
If c.Value Like "*" & st & "*" Then
-- __________________________________ HTH Bob "damorrison" wrote in message ... Hello, I am trying to search for partial strings in a cell, Sub Button1_Click() Dim r As Range Dim c As Range Dim st As String Set r = Range("A1", Range("A65536").End(xlUp)) st = InputBox("Enter Partial to Search", "Search By Address") For Each c In r.Cells If c = "*" & st & "*" Then '----The problem---- MsgBox c.Address End If Next c End Sub But do not know how to get the wildcard to work |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells using wildcards
Terrific,
Thanks for that |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells using wildcards
Great, thanks for that
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace with wildcards? | Excel Discussion (Misc queries) | |||
how to find cells that refer to data in other cells in excel | Excel Discussion (Misc queries) | |||
Why not accept wildcards for REPLACE as well as FIND ? | Excel Discussion (Misc queries) | |||
Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
How can I find strings of wildcards in Excel? | Excel Discussion (Misc queries) |