<p>When I create a graph after using range.copy and range.paste it leaves the paste range selected, and then when I create a graph a few lines later, it uses the selection as the first series in the plot.  I can delete the series, but is there a more elegant way to do this?  I tried </p>

<pre><code>Set selection = nothing
</code></pre>

<p>but it won't let me set selection.  I also tried selection.clear, but that just cleared the last cells that were selected, and still added an extra series to the plot.</p>

I do not think that this can be done. Here is some code copied with no modifications from Chip Pearson's site:
http://www.cpearson.com/excel/UnSelect.aspx
.
UnSelectActiveCell
This procedure will remove the Active Cell from the Selection.
```
```
Sub UnSelectActiveCell()
    Dim R As Range
    Dim RR As Range
    For Each R In Selection.Cells
        If StrComp(R.Address, ActiveCell.Address, vbBinaryCompare) <> 0 Then
            If RR Is Nothing Then
                Set RR = R
            Else
                Set RR = Application.Union(RR, R)
            End If
        End If
    Next R
    If Not RR Is Nothing Then
        RR.Select
    End If
End Sub
```
```
UnSelectCurrentArea
This procedure will remove the Area containing the Active Cell from the Selection.
```
```
Sub UnSelectCurrentArea()
    Dim Area As Range
    Dim RR As Range

    For Each Area In Selection.Areas
        If Application.Intersect(Area, ActiveCell) Is Nothing Then
            If RR Is Nothing Then
                Set RR = Area
            Else
                Set RR = Application.Union(RR, Area)
            End If
        End If
    Next Area
    If Not RR Is Nothing Then
        RR.Select
    End If
End Sub
```
```