PDA

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



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

mdmackillop
02-01-2008, 12:50 PM
You can only have an active cell on an active sheet, in which case this should work.

Sheets("Symbols").Range("A3").Copy ActiveCell


If ScoreCard is not active, you'll need to provide an address.

coliervile
02-01-2008, 01:11 PM
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
02-01-2008, 03:58 PM
Thanks MD I got it to work. Have a great day.

Best regards,

Charlie

GalileoGali
02-01-2008, 05:12 PM
Deleted