title: Creating Dynamic Range based on cell value
body: <p>I'm new to VBA and I'm trying to create dynamic ranges based on cell values contained in column A.  There are many ranges on the same sheet and the size of each range will change, thus I cannot identify a cell as the starting point for a range, since it will change.  I have a list of the different range names in column A of Sheet 2, which I can use to create the different ranges if needed. I'm thinking the best way to do this is using find, but again, I'm very new to this. Here's what I have so far (not much, I know). Any help is greatly appreciated! Thanks! </p>
  
  <pre><code> Sub NameRange()
  
  Dim rngselect As Range, FinalRange As Range, cell As Range
  Dim ws As Worksheet
  
  Set ws = Worksheets("OOE")
  Set rngselect = ws.Range("$A:Z")
  
  ws.Columns(i, 1).Find(California).Select
  .Name = "Cali"
  
  End Sub
  </code></pre>