title: Simple VBA to Select a Range from First .Find Value?
body: <p>I want to locate a value within column "A" then select from that address to the first blank row encountered. Here is what I have, but Set f isn't working. My Set c works and returns $A$32, which is the correct address. What am I missing?</p>
  
  <pre><code>With Workbooks("MyBook").Sheets("Mysheet")
      Set c = .Range("$A:$A").Find("Red Car").Offset(2, 0)
      Set f = .Range(c.Address &amp; Range("A").End(xlDown).Row)
  End With
  </code></pre>