title: Excel VBA Find/Replace Macro
body: <p>Good Morning,</p>
  
  <p>I am working with a rather large dataset and I am attempting to Find/Replace values which have been modified in one spreadsheet back into the original.  What I would like to do is have the macro look for the information in Cell A1 and Replace it with the value in Cell B1, and then continue down until Cell A3600:B3600. Generally, I'm pretty good at peicemealing the code I find on here to get it to do what I want, but I'm at a loss as to what I should be looking for.</p>
  
  <p>What I have right now is:</p>
  
  <pre><code>Sub Macro1()
  '
  ' Macro1 Macro
  '
  
  '
  Range("A1").Select
  
  Selection.Copy
  Cells.Replace What:=ActiveCell.Value, Replacement:="????", LookAt:=xlPart, _
      SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
      ReplaceFormat:=False
  End Sub
  </code></pre>
  
  <p>From here I am at a loss.  I understand <em>Range("A1").Select</em> will paste into the Find section of the Find/Replace box, but how do I tell excel I want to select another Cell, in this case B1, for the replace portion? And then how do I tell Excel I want it to keep doing this until it runs out of values in the A Column?</p>
  
  <p>Thank you in advance for any assistance you can provide.</p>