C
Chris
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.
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.