How to assign Selection.Copy value to a String in Excel VBA
<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>