Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For discussion sake, let's have three tabs in our spreadsheet:
Tab1 - complete hockey schedule (home team column A, visiting team column B) Tab2 - column A has complete list of eastern teams and is named "EasternTeams" Tab3 - column A has complete list of western teams and is named "WesternTeams" Is it possible to have a find routine identify every game where a home team is from the West? As long as I use an individual and specific city, I can get it to work fine ex. Cells.Find(What:="Seattle", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate Then a little loop allows me to go through and highlight all of the Seattle games. Is it possible to find all instances of all Western teams (named range)? I haven't managed to get this to work. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find last used cell (row) in a named range | Excel Programming | |||
Find Row in a named range | Excel Worksheet Functions | |||
Find Cell in Named Range | Excel Worksheet Functions | |||
find within a named range, then deselect the range | Excel Programming | |||
How to find all formulas that used a certain named range | Excel Discussion (Misc queries) |