Range expects a string or TWO cells to define the range.
With only one CELL remove the RANGE:
wsCopy.Cells(2,8).Copy
When using two cells it would be something like this:
wsCopy.Range(wsCopy.Cells(2,8),wsCopy.Cells(4,10)).Copy
If instead you have the range desired as a string in the the cell one would need to append .Value
to the Cells()
wsCopy.Range(wsCopy.Cells(2,8).Value).Copy
Now it will take the value in that cell as a string an pass it to the Range.
Also skip the dual lines:
wsCopy.Cells(2,8).Copy wsDest.Range("J5")
Copy takes an argument of the destination.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…