title: How to assign Selection.Copy value to a String in Excel VBA
body: <p>I am new to VB and Macro.</p>
  
  <p>I'm trying to copy contents of a cell from one sheet and assign it to a string so that I can pass the string wherever I want to.</p>
  
  <p>Here is what I am trying to do and it isn't working.</p>
  
  <pre><code>Dim findd As String
  Columns("A:A").Select
  Windows("Book111.xlsm").Activate
  Range("A1").Select
  Selection.Copy
  findd = Selection.Paste
  Windows("Book2.xls").Activate
  Selection.Replace What:=findd, Replacement:="", LookAt _
      :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
      ReplaceFormat:=False
  </code></pre>