title: Selecting a range that is from one cell to a found value?
body: <p>I'm making some sparklines and I'm trying to reference a range for the source data.  The Problem is that the Range is added onto every month.  I need to be able to use a range from a known first cell to until it finds a value.Offset(0,-1)  </p>
  
  <pre><code>Dif wb As Workbook 
  Dif ws As Worksheet 
  
      Set wb = Workbooks("HardDrive location")
      Set ws = wb.Worksheets("Sheet1")
  
  wb.ws.Range.Rows(4).Cells.Find("XXX").Offset(0, 1).Select
  
  Selection.SparklineGroups.Add Type:=xlSparkLine, SourceData:= Range("D4", wb.ws.Range.Rows(4).Find("XXX").Offset(0,-1))
  
  'Other Parameters are below, but there aren't any problems past this point'
  </code></pre>
  
  <p>Not really sure how to get that to work. Any help would be appreciated.  </p>