Find String, Identify Cell

[BrianExcel]

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.

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)

 

[BrianExcel]

I need to identify which cell contains those words so a later bit of code can parse just the date range for a chart title.

 

[Michael M]

Row 6 looks like a merged cell ?
If that's the case you need to look in the leftmost column !
Also look at using the InStr function to search within a given string