-
Solved: Copy and Paste to an Active Cell on a Different Worksheet
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
-
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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
-
Thanks MD I got it to work. Have a great day.
Best regards,
Charlie
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules