Solved: Copy and Paste to an Active Cell on a Different Worksheet

[coliervile]

I want to copy a cell from a worksheet named "Symbols" to an active cell on a worksheet called "Scorecard". Here's what I've come up with, but I can't get it to copy to the active or selected cell on the other worksheet. It does copy, but to another cell on the "ScoredCard" worksheet thats not active or selected.

Best Regards,

Charlie

Sub F7()

Sheets("Symbols").Range("A3").Select
Selection.Copy
Sheets("ScoreCard").Select
Range(ActiveCell).Select
ActiveSheet.Paste

End Sub

[mdmackillop]

You can only have an active cell on an active sheet, in which case this should work.
[VBA]
Sheets("Symbols").Range("A3").Copy ActiveCell

[/VBA]
If ScoreCard is not active, you'll need to provide an address.

[coliervile]

Thanks MD for responding. I tried your coding, but it didn't copy the cell to the active or selected cell on the "ScoreCard" worksheet. I would post my worksheet, but my HTML is turned off on my VBAExpress for some reason and can't figure out how to turn it on.

Best regards,

Charlie

[coliervile]

Thanks MD I got it to work. Have a great day.

Best regards,

Charlie

[GalileoGali]

Deleted