how to copy and paste Closed

Question

Hello, 

I want to copy something from the 1st worksheet and paste to 2nd worksheet.
I have already the code but did not work.
What's wrong with this. can you correct this one?
Sub trans()
With Worksheets("English")
    Range("B54:Q71").Select
    Selection.Copy
    End With
    
    With Worksheets("French")
    Range("B54").Select
    ActiveSheet.Paste
    End With

End Sub

Configuration: Windows XP / Internet Explorer 8.0

rizvisa1 · Answer

You are not activating the sheet. "WITH" is only a shortform but does not select sheet

sheets("English").Select
Range("B54:Q71").Select
Selection.Copy


Sheets("French").Select
Range("B54").Select
ActiveSheet.Paste

How to copy and paste

1 response

Similar discussions

Subscribe To Our Newsletter!