Find a Cell Based on Text and then Extract Date Range

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
969
I am using the following code to find the cell containing the words "Reporting Dates":

VBA Code:
    With ActiveWorkbook.Worksheets("Stats")
        Set DateRangeEdits = .Cells.Find(What:="Reporting Dates", LookIn:=xlValues, lookAt:=xlPart)
    End With

Within that cell is a varying date range, but the cell will ALWAYS Start with the text "Reporting Dates - ".

I need to extract the date range, basically everything RIGHT of the "-", to parse it as a string to pass into a chart.

I can't seem to get it to work...
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,512
Office Version
  1. 365
Platform
  1. Windows
Try this:
VBA Code:
    Dim DateRangeEdits As Range
    Dim DateRange As String
   
    With ActiveWorkbook.Worksheets("Stats")
        Set DateRangeEdits = .Cells.Find(What:="Reporting Dates", LookIn:=xlValues, lookAt:=xlPart)
    End With
   
    DateRange = Mid(DateRangeEdits, 19)
   
    MsgBox DateRange
 

Watch MrExcel Video

Forum statistics

Threads
1,127,103
Messages
5,622,742
Members
415,925
Latest member
Ryle23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top