Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA searching
Hi Guys,
I've got to grips with this - which finds the first occuarnce of 2 in range A1:A500. With Worksheets(1).Range("a1:a500") Set c = .Find(2, lookin:=xlValues) If Not c Is Nothing Then firstAddress = c.Address End If End With (Thank you Bob) However if I had two cells side by side e.g B3 = "Hello" D3 = "Fred" And I have "HelloFred" to search for - wanting the 3 returned (I already know the columns), can that be acheived in a similar manner to the above? Many thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
searching for tab | Excel Discussion (Misc queries) | |||
searching | Excel Worksheet Functions | |||
searching for a value... | Excel Programming |