BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
How do I modify the below code to find the cell containing the specific words "Reporting Dates". FYI, the cell I am trying to identify does not JUST contain those words. It also contains a date from and date to range.
Set DateRangeBallEdits = Cells.Find(What:="Reporting Dates", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart)
Venus Ball Stats (5.25-6.01).xlsx | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
5 | |||||||||||||||||
6 | Reporting Dates - 5/25/2020 to 6/1/2020 | ||||||||||||||||
7 | |||||||||||||||||
Venus Ball Stats |
Set DateRangeBallEdits = Cells.Find(What:="Reporting Dates", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart)
Last edited: