coliervile
02-01-2008, 12:30 PM
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
Best Regards,
Charlie
Sub F7()
Sheets("Symbols").Range("A3").Select
Selection.Copy
Sheets("ScoreCard").Select
Range(ActiveCell).Select
ActiveSheet.Paste
End Sub